Results 1 to 2 of 2

Formula To Index All Unique Values Found Based on Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    11-20-2015
    Location
    Rogers
    MS-Off Ver
    365
    Posts
    23

    Formula To Index All Unique Values Found Based on Criteria

    In sheet two of the attached, I'm looking for a formula to return all the unique item numbers from column A in the data tab where 1) the item in A2 has a qty >0 in column G, 2) column H in the data tab has a value greater than 0 and 3) where the both items were on the same PO from column C in the data tab. I've been trying to think through the best was to find a unique identifier to sumif off of so that is what is in I through K of the data tab. Thanks in advance. Think I've fried my brain on this one and missing something probably simple.
    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. Formula to return unique values based on 4 criteria
    By thomasuponor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-24-2020, 05:15 AM
  2. 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
  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. [SOLVED] Index & Match Formula with Unique Values bases on a criteria
    By Neilesh Kumar in forum Excel General
    Replies: 5
    Last Post: 03-24-2017, 06:22 AM
  6. [SOLVED] Unique Values Formula Based on Criteria
    By zmster2033 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-07-2014, 10:03 PM
  7. Index formula that returns only unique values based on cell value
    By wakerider05 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-05-2014, 09:37 AM

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