PDA

View Full Version : How to count unique values in specific names


Burdugoy
May 30, 2009, 04:31 AM
Hi guys,

Anyone can help me what is the formula in excel MS office 2007
Of counting the unique numbers in one column A against column B
Example:

Column A (Cheque Numbers) Column B

1234 Charice
1235 Charice
1235 Charice
1233 Isabel
1236 Isabel
1236 Isabel

How many cheques received by Isabel and Charice
Please help.
Thanks

JBeaucaire
Jun 4, 2009, 01:17 AM
Like this:

=SUMPRODUCT(--($B$1:$B$10="Charice"),--($A$1:$A$10<>"")/COUNTIF($A$1:$A$10,$A$1:$A$10&""))