=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))


Gord Dibben MS Excel MVP

On Tue, 24 Nov 2009 10:32:03 -0800, kevin giblin wrote:

following on from the counting of multiple selections once, how do excel to count a a list of card number with duplicates once.

For exapmle a list of card numbers would look like this

Card number

11111 22222 33333
11111 22222 33333
11111 22222 33333
44444 55555 66666

the aswer would be two as two once card number has been inserted 3 times?

EggHeadCafe - Software Developer Portal of Choice
ADO.NET Programmer's Reference
http://www.eggheadcafe.com/tutorials...mers-refe.aspx