Hi,
I want to do an analysis on a portfolio based on size on account. First step is to map the companies and groups. To be able to do that I need to get the distinct values (cust nr) from a larger dataset. I tried several formulas for example:
=IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$10), 0)), "")
As is:
To be:
Is this something that can be done easily?
I want to do an analysis on a portfolio based on size on account. First step is to map the companies and groups. To be able to do that I need to get the distinct values (cust nr) from a larger dataset. I tried several formulas for example:
=IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$10), 0)), "")
As is:
To be:
Is this something that can be done easily?