Why didn't you say so?

Use this array formula

=SUM(--(FREQUENCY(IF(B2:B100="Paris",MATCH(A2:A100,A2:A10 0,0)),ROW(INDIRECT("1:"&ROWS(A2:A100))))0))

--

HTH

Bob

"Louja" wrote in message
...
I get that formula and it works well for all the individuals but say I
wanted to count how many different individuals were in London / Paris
(see below) how would I get this to work

Name Group
Adam Smith London
John Pickles Paris
Lee Adams Paris
Ben Jones London
Adam Smith London
John Pickles Paris


Thanks again

Louisa