Hello All
I am not sure if it is appropriate to ask for helping understand how to use Excel functions.
I was given this formula to help create a unique list....this formula below provides the unqiue data for column K. The column is changed to get the unique data for that column.
=IFERROR(
INDEX($C$5:$X$241,
MATCH(ROW(BX1), $J$5:$J$241,0),
MATCH($K$5, $C$5:$X$5,0)),"")
It works.... but I dont understand how. I am having trouble with another issue (I have it posted it here on the site that hasnt been solved yet) and I am hoping to leverage this to hopefully resolve my other problem.
This is what I understand...
INDEX($C$5:$X$241 is setting the area within the excel document where the forumla is to be applied.
BX1 is just a way to keep track of the rows.
0 is saying it needs to be an exact match.
$J$5:$J$241 contains a running total in my data that is a running total of a unique entry (so if there were 100 data entries, but only 5 were unique, that column would have the numbers 1-5).
I don't understand...
MATCH($K$5, $C$5:$X$5
Why is the first part only referring to one cell, specifically the $K$5?
In my data the column K has a lot of duplicates, but it appears that only the very first cell is used for comparison. So I don't understand how it only looks at one cell....but returns a unique values for the entire column.
How is that getting the correct information? I mean it works... but i am missing the logic.
thanks for your help
Joanne
Bookmarks