SOLVED 
=IFERROR(ROWS(UNIQUE(FILTER(Report!$F$2:$F$960,(Report!$F$2:$F$960<>"")*(Report!$B$2:$B$960=B23)))), 0)
Hi,
I have a table with a number of different locations (column a). I'm trying to find a formula which will tell me how many different people have registered against each location
EG:
East John
East John
East Mary
East Bob
East Bob
East Russell
West Susan
West Rachel
North Joan
How many people at East: answer being 4
Thanks
=IFERROR(ROWS(UNIQUE(FILTER(Report!$F$2:$F$960,(Report!$F$2:$F$960<>"")*(Report!$B$2:$B$960=B23)))), 0)Hi,
I have a table with a number of different locations (column a). I'm trying to find a formula which will tell me how many different people have registered against each location
EG:
East John
East John
East Mary
East Bob
East Bob
East Russell
West Susan
West Rachel
North Joan
How many people at East: answer being 4
Thanks
Last edited: