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:
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...
Why is the first part only referring to one cell?
In my data that one cell has a lot of duplicates, so I don't understand how it can come up with a uique value.
How is that getting the correct information? I mean it works... but i am missing the logic.
thanks for your help