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