Results 1 to 16 of 16

Index Match (multiple criteria) Skipping Duplicates & Returning Only Unique Values

Threaded View

  1. #1
    Registered User
    Join Date
    10-07-2014
    Location
    escondido
    MS-Off Ver
    2016
    Posts
    10

    Index Match (multiple criteria) Skipping Duplicates & Returning Only Unique Values

    Hi, I have been desperately trying to figure this one out. I have assigned a unique value to a set of numbers. I am trying to return the unique value based on two criteria (Dollar amount & Period). The problem i am have is that there could be more that one occurrence where the dollar amount and the period are the same. When this is the case the unique value comes back the same (the first occurrence). I need the formula to skip if the unique value that has already been used and return the next based on the same criteria. I have attached my document. Very simple spreadsheet and very intuitive. Thanks
    Attached Files Attached Files
    Last edited by AliGW; 09-04-2019 at 01:19 AM. Reason: Irrelevant section of title removed: this is a HELP forum!!!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. index match multiple unique values based on one criteria
    By Clooney003 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-10-2019, 10:03 PM
  2. Replies: 6
    Last Post: 08-21-2018, 05:45 PM
  3. [SOLVED] Index & Match Formula for Unique Values On Multiple Criteria
    By JenMasters84 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-10-2018, 03:01 PM
  4. [SOLVED] Index & Match Formula for Unique Values On Multiple Criteria
    By Neilesh Kumar in forum Excel General
    Replies: 2
    Last Post: 03-24-2017, 10:13 AM
  5. Index/match for multiple criteria when duplicates exist
    By dasranch in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-26-2015, 12:05 AM
  6. [SOLVED] Two criteria Index Match on multiple sheets returning multiple values
    By Joak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2014, 10:03 AM
  7. [SOLVED] Index match with multiple criteria and returning last value
    By L.Steele in forum Excel General
    Replies: 2
    Last Post: 05-30-2012, 02:27 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