I have tried to use this formula and it comes back with 0

On 12 Mar, 09:41, "Bob Phillips" wrote:
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