Results 1 to 2 of 2

Thread: Change INDEX MATCH Function to UNIQUE FILTER for sorting data

  1. #1
    Neophyte tpampalone's Avatar
    Join Date
    Feb 2021
    Posts
    1
    Articles
    0
    Excel Version
    Excel 365

    Change INDEX MATCH Function to UNIQUE FILTER for sorting data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I am relatively new to Excel and its formulas.

    I am work on a task to revise and INDEX, MATCH function and replace it with the UNIQUE & FILTER functions.

    The example I am working on is the following:
    - Search for top value of one column (qty) and bring the cost of those items (Line amount) with them

    Here's the formula that does so right now: =INDEX('Per SKU'!$C:$C,MATCH(C5,'Per SKU'!$K:$K,0))

    This is applied across 10 rows to give me a top 10 list of the top qtys and their total amounts associated.

    The issue is that with this function it returns duplicate values.

    Could someone help provide a solution using the UNIQUE function given the formula I have provided?

    Thanks.
    Last edited by AliGW; 2021-02-28 at 08:18 AM. Reason: Redacted for legibility.

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,618
    Articles
    0
    Excel Version
    Office 365 Subscription
    Welcome to the forum.

    Attach a sample workbook, please. Your formula does not inherently pull a top five list, nor does it sum anything, so we need to see the context.
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •