Forum Discussion
How to search on one column and then count distinct entries in another column (Excel)
I am trying to compare sales data from two tables. The first table shows product info (Location, product code etc.), and the second table shows all transaction data (Location, product code, customer ...
Slightly modified formula suggested by OliverScheurich if use structured tables
which is
=LET(
f, FILTER(
Orders[Customer],
( Orders[Location] = [@Location] ) *
( Orders[Product Code] = [@[Product Code]] ) ),
COUNTA( UNIQUE( f ) ) )