Counting Numbers of Same Frequency

  • Thread starter Thread starter Rothman
  • Start date Start date
R

Rothman

I have a column of random numbers. Is there a way of counting the numbers
that appear the same, given number of times in the column in a formula? For
instance, if numbers a, b and c appear x times, then the answer would be 3.

Thanks in advance.
 
try
=SUMPRODUCT(--(FREQUENCY(A1:A14,A1:A14)=2))
change range reference as needed
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Frequency vs Count 10
Help with Count formula 2
Take me to the number 1
Excel Issue with "Average" showing in Status Bar 2
Count 3
COUNT function - # of occurences a number appears in all cells 26
Multi-demensional frequency distribution 4
How to do the calculation - 29 Nov? 3

Back
Top