+ Reply to Thread
Results 1 to 5 of 5

Extracting+Duplicates+Unique in two different sheets

  1. #1
    Registered User
    Join Date
    04-02-2022
    Location
    India
    MS-Off Ver
    2016
    Posts
    4

    Extracting+Duplicates+Unique in two different sheets

    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.
    Last edited by Glenn Kennedy; 04-02-2022 at 08:18 AM.

  2. #2
    Registered User
    Join Date
    03-03-2022
    Location
    Brazil
    MS-Off Ver
    365
    Posts
    3

    Re: Extracting+Duplicates+Unique in two different sheets

    Is there any way to share the spreadsheet with us? This makes it easier to help a solver:

  3. #3
    Registered User
    Join Date
    04-02-2022
    Location
    India
    MS-Off Ver
    2016
    Posts
    4

    Re: Extracting+Duplicates+Unique in two different sheets

    Please find the sheets

    docs.google.com/spreadsheets/d/1JMRdbc37c9DzLVyg6lX6oQhlkf_itJNfdlhbCs9ewBo/edit?usp=sharing
    Last edited by ijlprexcel; 04-04-2022 at 01:06 AM. Reason: missing text

  4. #4
    Registered User
    Join Date
    04-02-2022
    Location
    India
    MS-Off Ver
    2016
    Posts
    4

    Re: Extracting+Duplicates+Unique in two different sheets

    Hi daphneml

    Kindly help

  5. #5
    Registered User
    Join Date
    04-02-2022
    Location
    India
    MS-Off Ver
    2016
    Posts
    4

    Re: Extracting+Duplicates+Unique in two different sheets

    Since its been a week, i have not got any result. so am posting to other platform. kindly delete this thread

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula for extracting unique list from different sheets
    By XLalbania in forum Excel General
    Replies: 10
    Last Post: 11-12-2016, 02:46 PM
  2. [SOLVED] Macro to find duplicates, concatenate Unique Values, then delete old duplicates
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2013, 04:32 PM
  3. Move Unique records and Duplicates in separate sheets
    By fareen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2013, 03:30 AM
  4. [SOLVED] Applying unique ID's to rows but keep same unique ID number for duplicates
    By sirjames2829 in forum Excel General
    Replies: 2
    Last Post: 12-11-2012, 06:14 PM
  5. Difficult: Removing duplicates between 2 sheets, or copying Unique rows.
    By RonaldRS in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-02-2012, 09:03 AM
  6. Replies: 5
    Last Post: 06-22-2012, 04:03 PM
  7. Replies: 6
    Last Post: 03-29-2012, 12:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1