Forum Discussion
Excel count
I have a dataset that involves two columns, Customer ID and Product. The green highlighted is what my final results should be. I need to find the total number of unique customers that only ordered ap...
Because, at this stage in the game, it is probably cheating to use UNIQUE(), it is also possible to use MATCH to reduce the number of instances of each customer to one
= SUM( IF(
MATCH(Customer, Customer, 0 ) = Index,
SIGN( COUNTIFS( Customer, Customer, Product, "apples" ) ),
0 ) )
Index is a helper column containing the row number. These-days I would want to use
= SEQUENCE( ROWS(Table) )
but meanwhile an index column can be added by hand or by using ROW().