It’s been years since I’ve done anything with Excel so I’m sorry for such a simple question. I’ve attached a file and I know how to find out how many times a particular number comes up in a list of numbers using the COUNTIF command as demonstrated using 10 numbers, but what if my list were really long like 1,000 numbers using 100 different numbers? I really need to know which 3 numbers in the 100 came up the most often and which 3 numbers in the 100 came up the least often. What would be the easiest way to do this?
Thanks in advance for any help you can provide!
Tom
Bookmarks