I am a new Excel user so bear with me while I learn.
I have Excel 2007...
I have a long list of numbers in a column (A1 - A520)
The number are all between 1 and 100
Is it possible to see how many time each number is on the list?
ie. 5 is on the list 22 times
Ideally I need to find the top 7 number patterns
ie. 5 - 22
10 - 20
12 - 19
and so on
Edit to add: I add between 3 and 22 numbers twice a week.
Bookmarks