counting recurring #'s in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to count the number of times each # within a column repeats it's
self.
I am completely lost!
 
Hi

With data in column A, enter in B1
=COUNTIF(A:A,A1)
and copy down
 
If you know the unique numbers you can use the FREQUENCY function.

Say you have the numbers 1 through 9 multiple times randomly in A1:A50

In B1:B9 enter numbers 1 to 9

Select C1:C9

In C1 enter =FREQUENCY(A1:A50,B1:B9) then hit CTRL + SHIFT + ENTER


Gord Dibben MS Excel MVP
 
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

Count range of cells if not next to each other 0
count values in a range of cells depending on value in adjacent ce 1
Counting 3
countif 3
Function in Excel to count and list number of entries of text valuesin a row. 2
Counting results of a formula 9
Formula (or code) return the largest number of duplicates in a list. 16
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top