Hi guys,

I just found this:
https://stackoverflow.com/questions/...alues-in-excel

I dont understand how the "MATCH(, COUNTIF($B$1:B1, $A$2:$A$25), 0)" part works.

I do understand how the COUNTIF returns an array of something like {0;1;1;0;0;...}

I don't understand how Match(,{0;1;1;0;0;...},0) becomes "1 or 2 or 4", etc, which INDEX then uses to return unique values/string.


Thanks,
Jimmy