Hi Team,
I have attached a excel file(3 sheets),
Sheet1 - Form Responses 1-Its a google form response page, contains title, name of the reviewers, qualification and email id. There may be one and more than one reviewers for one single title.
Sheet2-Title-Data contains unique title name. Count can be varry.
Sheet3-Result-Unique name of the reviewer with their respective qualifications and emailid. (Requirement)
Requirement:
In result sheet, i need unique name(reviewer), with their respective qualifications and emailid.
Sheet1 and sheet2 are datas which we will enter. Sheet3 should be the result.
There can be same name(reviewer) for different title, but we need unique names.
here may be one and more than one reviewers for one single title.
You can use vba script or formula, we are using ms 2016.
Kindly help me in this.
Bookmarks