Counting Occurence of Repeat Numbers

  • Thread starter Thread starter NickC
  • Start date Start date
N

NickC

I have a list of random numbers in one column. Some of these numbers are
repeat numbers. Is there a way of automatically counting the numbers of
times each number appears in the list
 
Nick,

A pivot table can do this. Drag the heading for the column into the row
area, and into the data area. Set it to COUNT. The steps vary slightly
depending on the release of Excel.
 
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

SUMIFS ONLY UNTIL the number REPEATS 1
Count in a range of numbers 8
Counting frequency of numbers in a column 3
counting formula 3
Create random list - dublicates are okay but not right after each other 2
Which function to use......and how? 4
How to list and count unique records 4
Count Values in a Range, Not Formulas 2

Back
Top