Results 1 to 5 of 5

Using One Column To Find Unique Values in Another Column

Threaded View

Meoxdide Using One Column To Find... 06-06-2019, 06:16 PM
FDibbins Re: Using One Column To Find... 06-06-2019, 11:38 PM
Meoxdide Re: Using One Column To Find... 06-07-2019, 11:12 AM
kvsrinivasamurthy Re: Using One Column To Find... 06-07-2019, 12:13 PM
Meoxdide Re: Using One Column To Find... 06-07-2019, 01:18 PM
  1. #1
    Registered User
    Join Date
    06-06-2019
    Location
    California
    MS-Off Ver
    2010
    Posts
    3

    Using One Column To Find Unique Values in Another Column

    I have one column that has different schedule numbers. These show up many times and can have multiple suppliers associated with them. I want to make a formula that will look at each schedule in one column and give me the name of the first unique supplier, second unique supplier and so on. Finding and listing unique suppliers is not difficult in excel, the tricky part is using a different column to base my search off of. I attached a snippet of my spreadsheet that applies and it should be more clear when looking at it. The main sheet I use has hundreds of schedules and I need to find which suppliers are used for each one using a formula than can sort through it as I constantly update the table.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 17
    Last Post: 02-02-2017, 04:13 PM
  2. [SOLVED] Find unique values between columns and copy to new column
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-31-2015, 09:48 AM
  3. best way to find unique values of three column
    By intouch01 in forum Excel General
    Replies: 2
    Last Post: 01-13-2015, 02:32 AM
  4. best way to find unique values of two column
    By intouch01 in forum Excel General
    Replies: 1
    Last Post: 01-08-2015, 12:39 AM
  5. Find duplicate values for unique column
    By zammy73 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2014, 06:45 PM
  6. How to find all unique values then combine in a new column?
    By terry mardi in forum Excel General
    Replies: 3
    Last Post: 07-09-2013, 10:20 AM
  7. Find duplicate values in a column, make each value unique.
    By jobell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2012, 12:15 PM

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