tpampalone
New member
- Joined
- Feb 24, 2021
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 365
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.
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 a moderator: