Donate SIGN UP
Home > Technology > Computers > Excel CountIF and CountD

Excel CountIF and CountD

Avatar Image
funkylad20 | 08:48 Fri 13th Mar 2009 | Computers
2 Answers
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?
prev English Grammer Software
  
next Running Virus Checks
Gravatar

Answers

1 to 2 of 2rss feed

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.
Avatar Image 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))
09:02 Fri 13th Mar 2009
Avatar Image 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)
11:12 Fri 13th Mar 2009

1 to 2 of 2rss feed

Do you know the answer?

Excel CountIF and CountD

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.