• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MS Excel question (Find most common number)

B

BigToque

Lifer
Say I have a set of numbers in a column (say 20 numbers)

How do I get excel to find out which number is the most common? or even the 2 most common? Is there anyway to make it show all numbers in the column and give a breakdown of all the numbers?

Should I use a chart? Would I use a macro?

 
Well another question that I dont know the answer to...

Is there any way to retrieve the top (X) most common numbers and display those numbers in other cells?

 
I suppose you could use the COUNTIF function to get the count of each number in your range and then order these values and just get the top x.
Not an ideal solution I know, but I'm not aware of any function in Excel that does exactly what you are after.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top