Can you sort by most to least often recurring number in Excel?

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

Guest

I know there is a Mode formula to find the most often recurring number, but
can I build on that and sort the list to have the most often recurring number
at the top and least often at the bottom and vice versa?
 
Just use a "helper" column:

If your values are in A1 thru A100, then in B1 enter:

=COUNTIF(A$1:A$100,A1) and copy down

Then sort the pair of columns by column B descending
 
Thank you Gary''s Student!! I was using a helper column, but the =log
formula, and I couldn't quite get it right. This is great! Thanks!!
 

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

Function in Excel to count and list number of entries of text valuesin a row. 2
How can I find out if numbers in one column are also in a secondcolumn please? 9
Determine Most/Least Frequent Date from List 2
Convert Decimal fractions to binary and vice versa 1
Trouble with vlookup and numbers stored as text 3
Mathematics: How to display numbers/characters with a line over th 3
Sorting Recurring and One-time Appointments in List View 1
Trouble with Recurring Tasks 5

Back
Top