Results 1 to 15 of 15

Need help with formula to list unique values from a list based on a condition

Threaded View

mischge Need help with formula to... 08-03-2016, 04:22 PM
Pete_UK Re: Need help with formula to... 08-03-2016, 04:57 PM
Tony Valko Re: Need help with formula to... 08-03-2016, 05:01 PM
mischge Re: Need help with formula to... 08-03-2016, 05:16 PM
Tony Valko Re: Need help with formula to... 08-03-2016, 05:17 PM
Pete_UK Re: Need help with formula to... 08-03-2016, 06:08 PM
mischge Re: Need help with formula to... 08-04-2016, 09:16 AM
Tony Valko Re: Need help with formula to... 08-04-2016, 09:46 AM
Pete_UK Re: Need help with formula to... 08-04-2016, 10:06 AM
mischge Re: Need help with formula to... 08-04-2016, 10:23 AM
Pete_UK Re: Need help with formula to... 08-04-2016, 10:28 AM
mischge Re: Need help with formula to... 08-04-2016, 10:39 AM
Tony Valko Re: Need help with formula to... 08-04-2016, 10:35 AM
mischge Re: Need help with formula to... 08-04-2016, 02:13 PM
Tony Valko Re: Need help with formula to... 08-04-2016, 02:18 PM
  1. #1
    Registered User
    Join Date
    07-30-2013
    Location
    binningen
    MS-Off Ver
    Excel 2010
    Posts
    28

    Need help with formula to list unique values from a list based on a condition

    Please help! As soon as I insert the IF function around the INDEX/MATCH function, the formula stops working.

    I am looking to get all values from a list based on a condition, i.e. i need the origins for one particular destination.
    A simplified sample data set is attached, including my failing formula.

    The result I'm looking for, based on all Canadian origins, is:
    French - 25'000
    German - 20'000

    Duplicates should not be omitted, i.e. if there were 2 French origins, they should appear on separate rows in the new list.

    Thanks for your support in advance!
    Attached Files Attached Files
    Last edited by mischge; 08-03-2016 at 04:25 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Validation List - Formula to Sort and Return Unique Values in List
    By beewketu in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2015, 04:18 PM
  2. List Unique Values Based On Criteria
    By tangmere.milli in forum Excel General
    Replies: 5
    Last Post: 03-16-2015, 09:49 AM
  3. [SOLVED] Unique list based on condition
    By bdrilling33 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-11-2014, 10:27 AM
  4. [SOLVED] formula required to list cell values based on condition
    By kiranpat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 04:54 AM
  5. [SOLVED] Need unique list based on another list and incorporating =RIGHT(...) formula
    By NS4Excel in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 03-31-2014, 10:10 PM
  6. [SOLVED] Count unique values and create list based on these values
    By vipa2000 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  7. [SOLVED] Counting unique items in a list based on a condition
    By George Lynch in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-11-2005, 09:06 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