List of Data and want to count them only if they are not dupes

[kidnos]

Hi, I have a list of data in column A, say:
,"365",1280
,"476",1280
,"596",1280
,"596",1280
,"40",1280
,"41",1280
,"53",1280
,"104",1280

I pulled it into excel from a comma delimited text file.
Well, I would like to count how man clients we have but exclude duplicate entries. So in this case wehn you total them there are 8 rows but only 7 clients b/c 596 is in there twice. We had an access query to do it but it dissapeared and I am certain excel can do it quicker. Would I use the COUNTIF function? Thanks

 

[Loomah]

Hi
Have a look and see if anything here helps you

http://www.cpearson.com/excel/duplicat.htm

happy friday

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[kidnos]

This seemed to work so far:
=SUMPRODUCT((A1:A200<>"")/COUNTIF(A1:A200,A1:A200&""))

 

[xlbo]

and I very much doubt that excel will be quicker than access at this.....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[romualdezd]

You could get this info in 3 clicks. Create a pivot table from your xls. 2 things to note: Need a column heading and make what you are attempting to capture Column A of the pivot.