Excel CountIF and CountD

funkylad20 | 08:48 Fri 13th Mar 2009 | Computers

2 Answers

Subscribe
Report ⚑

I have a big list of unique reference numbers, some repeating, listed down column A.
How do I count the number of single entries, i.e. not count duplicates?

English Grammer Software

Running Virus Checks

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

funkylad20

Question Author

It's ok, I have sussed it out myself thanks!

for info, the answer is:
=SUM(IF(FREQUENCY(A1:A12,A1:A12)>0,1))

johnpol179

first of all open the excel and put all the entries in the excel than count the entries with the help of the excel calculator as

sum(if(frequency(a1,a2,a3)

1 to 2 of 2

Do you know the answer?