Prev: AutoFill Changing Wrong Value
Next: I know this is obvious but ..
From: Louja on 12 Mar 2010 05:23
I didn't say so as I only just figured that is what I wanted......
From: Louja on 12 Mar 2010 05:37
I have tried to use this formula and it comes back with 0

On 12 Mar, 09:41, "Bob Phillips" <bob.phill...(a)somewhere.com> wrote:
> Why didn't you say so?
>
> Use this array formula
>
> =SUM(--(FREQUENCY(IF(B2:B100="Paris",MATCH(A2:A100,A2:A100,0)),ROW(INDIRECT ("1:"&ROWS(A2:A100))))>0))
>
> --
>
> HTH
>
> Bob
>
> "Louja" <louisa.c.thomp...(a)googlemail.com> wrote in message
>
> news:e9b0088f-5ed3-404c-aafb-cd3ec49d2f92(a)33g2000yqj.googlegroups.com...
>
>
>
> >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

From: Louja on 12 Mar 2010 05:56
All works now - thank you very much.
First  |  Prev  | 
Pages: 1 2
Prev: AutoFill Changing Wrong Value
Next: I know this is obvious but ..