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!

 

[Guest]

Hi Jk,

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

hth
regards from Brazil
Marcelo

"JK57" escreveu:

 

[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!

That worked, thanks