+ Reply to Thread
Results 1 to 6 of 6

Need Help Extracting Unique Values Based on Another Cell Value

  1. #1
    Registered User
    Join Date
    06-28-2017
    Location
    Houston, Tx
    MS-Off Ver
    MS 2010
    Posts
    17

    Need Help Extracting Unique Values Based on Another Cell Value

    I am looking for help extracting unique values based on the value that is in the cell next to it.

    Screenshot.jpg

    In the screenshot, I have a Source Name in Column A and a Plan Name in Column B. What I am looking for is a formula that will give me the same information in column B if column A and B are both unique; i.e. if column A has Source 1 listed twice and column B has Plan 1 listed twice , then column C will show "Plan 1" for the first occurrence of this combination and return a blank for any subsequent occurrence. The main thing is the formula blank if the Column A/ B combination is duplicated.

    thanks in advance for the help.

    rgds,
    rb
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Need Help Extracting Unique Values Based on Another Cell Value

    Why not just remove the duplicates?

  3. #3
    Registered User
    Join Date
    06-28-2017
    Location
    Houston, Tx
    MS-Off Ver
    MS 2010
    Posts
    17

    Re: Need Help Extracting Unique Values Based on Another Cell Value

    kersplash,

    I need all of the data so I cannot delete the duplicates. I would also consider a manual copy / paste but the actual file I am working with is about 36k rows.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,220

    Re: Need Help Extracting Unique Values Based on Another Cell Value

    In C2 copied down:

    =IF(COUNTIFS($A$2:$A2,A2,$B$2:$B2,B2)=1,B2,"")
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  5. #5
    Registered User
    Join Date
    06-28-2017
    Location
    Houston, Tx
    MS-Off Ver
    MS 2010
    Posts
    17

    Re: Need Help Extracting Unique Values Based on Another Cell Value

    Thank you AliGW. It works!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,220

    Re: Need Help Extracting Unique Values Based on Another Cell Value

    You're welcome!

+ 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. Extracting Unique Values from Rows
    By fireboltpk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-29-2017, 10:13 AM
  2. Replies: 3
    Last Post: 11-22-2016, 06:11 AM
  3. [SOLVED] Extracting unique values from a list
    By vienvy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-08-2015, 12:49 AM
  4. **SOLVED**Extracting Unique Values Based On The Value In A Cell
    By rlh06 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-09-2014, 09:43 AM
  5. Extracting data from a row on one sheet into another sheet based on a unique cell
    By roshanvarghese in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-23-2013, 03:49 AM
  6. Extracting Unique Values
    By Drgenetix in forum Excel General
    Replies: 4
    Last Post: 08-04-2011, 06:38 AM
  7. Extracting unique values (without using filters)
    By stevemyers in forum Excel General
    Replies: 4
    Last Post: 09-20-2010, 04:39 PM

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