| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you sort by most to least often recurring number in Excel?
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can you sort by most to least often recurring number in Excel?
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 -- Gary''s Student - gsnu200745 "Jilly" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can you sort by most to least often recurring number in Excel?
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!! "Gary''s Student" wrote: 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 -- Gary''s Student - gsnu200745 "Jilly" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Spreadsheet Selection - Recurring Sort | Excel Worksheet Functions | |||
| How do I track recurring entries in Excel? | Excel Worksheet Functions | |||
| excel templete for monthly recurring deposit | Charts and Charting in Excel | |||
| Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
| how can I sort alphanumeric entries by number in excel | Excel Worksheet Functions | |||
Linear Mode
