Counting unique values

[JK57]

I have a series of names in column A and corresponding dates in column B. I need to find the number of unique dates (in serial form) corresponding to a name.

Col A Col B

Jones 38822
Smith 38822
Walker 38822
Jones 38822
Jones 38823
Jones 38823

In cell C1 I need to have the days associated with Jones, in this case, 2.

[Domenic]

Try...

=COUNT(1/FREQUENCY(IF(A1:A6="Jones",IF(B1:B6<>"",B1:B6)),IF(A1:A6="Jones"
,IF(B1:B6<>"",B1:B6))))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article <[email protected]>,
JK57 <[email protected]> wrote:

> I have a series of names in column A and corresponding dates in column
> B. I need to find the number of unique dates (in serial form)
> corresponding to a name.
>
> Col A Col B
>
> Jones 38822
> Smith 38822
> Walker 38822
> Jones 38822
> Jones 38823
> Jones 38823
>
> In cell C1 I need to have the days associated with Jones, in this case,
> 2.

[Marcelo]

Hi Jk,

=sumproduct(--(a2:a100="Jones")*(b2:b100=38822))

hth
regards from Brazil
Marcelo

"JK57" escreveu:

>
> I have a series of names in column A and corresponding dates in column
> B. I need to find the number of unique dates (in serial form)
> corresponding to a name.
>
> Col A Col B
>
> Jones 38822
> Smith 38822
> Walker 38822
> Jones 38822
> Jones 38823
> Jones 38823
>
> In cell C1 I need to have the days associated with Jones, in this case,
> 2.
>
>
> --
> JK57
> ------------------------------------------------------------------------
> JK57's Profile: http://www.excelforum.com/member.php...o&userid=33430
> View this thread: http://www.excelforum.com/showthread...hreadid=559010
>
>

[JK57]

Try...

=COUNT(1/FREQUENCY(IF(A1:A6="Jones",IF(B1:B6<>"",B1:B6)),IF(A1:A6="Jones"
,IF(B1:B6<>"",B1:B6))))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article <[email protected]>,
JK57 <[email protected]> wrote:

> I have a series of names in column A and corresponding dates in column
> B. I need to find the number of unique dates (in serial form)
> corresponding to a name.
>
> Col A Col B
>
> Jones 38822
> Smith 38822
> Walker 38822
> Jones 38822
> Jones 38823
> Jones 38823
>
> In cell C1 I need to have the days associated with Jones, in this case,
> 2.

That worked, thanks.