Results 1 to 4 of 4

Extracting multiple unique values from a table based on a single criterion.

Threaded View

  1. 11-21-2016, 08:14 PM #1
    alxes
    alxes is offline
    Registered User
    Join Date
    07-04-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    27

    Extracting multiple unique values from a table based on a single criterion.

    Hey all,

    I have seen similar problems to mine and I know I would have to use a mix of INDEX, MATCH and COUNTIF functions but unfortunately I just cannot get my head around the correct formulae.

    I have attached a spreadsheet with the database and 2 samples with examples of input and output.

    Thanks,
    Al
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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 a list in multiple columns into a single column (by formula)
    By Mukun in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-16-2016, 08:09 PM
  2. **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
  3. [SOLVED] Looking up multiple values based on a single criterion
    By wmjenner in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2013, 09:38 PM
  4. Need a Mcro to count unique values in selected cells based on a not-so-simple criterion
    By QZJ00 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-17-2012, 07:32 PM
  5. Extracting unique entries from table with multiple rows and columns
    By Bonnister in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2012, 11:48 AM
  6. VBA.array to sum values based on multiple criterion and dates
    By Varmark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2011, 09:33 PM
  7. [SOLVED] Find Multiple instances of Single Criterion in Row & Return To a Single Col
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-09-2006, 10:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1