| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort according to most repeated entries
Hello,
How can I sort a column based on repetition. For example, Anna Bob Bob Bob Bob Chuck Chuck Tiger Tiger Tiger Tiger Tiger Tiger Tiger Sam Sam Sam will be: Tiger Tiger Tiger Tiger Tiger Tiger Tiger Bob Bob Bob Bob Sam Sam Sam Chuck Chuck Anna |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort according to most repeated entries
I would insert a new column.
Then fill it with a formula like: =countif(a:a,a1) (and drag down as far as I need.) Then sort the range by this column (primary key, descending) and the original column (as the secondary key). Roadtripper902902V3V wrote: Hello, How can I sort a column based on repetition. For example, Anna Bob Bob Bob Bob Chuck Chuck Tiger Tiger Tiger Tiger Tiger Tiger Tiger Sam Sam Sam will be: Tiger Tiger Tiger Tiger Tiger Tiger Tiger Bob Bob Bob Bob Sam Sam Sam Chuck Chuck Anna -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort according to most repeated entries
Thanks, Dave. Your "countif" formula worked.
It didn't seem necessary to do the "secondary key" sorting. All I did after the getting the "countif" formula from top to bottom was just "sort" this new column of countif values by largest to smallest. Am I missing something? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort according to most repeated entries
If there are entries that show up with the same count, you may find those
entries mixed up. Roadtripper902902V3V wrote: Thanks, Dave. Your "countif" formula worked. It didn't seem necessary to do the "secondary key" sorting. All I did after the getting the "countif" formula from top to bottom was just "sort" this new column of countif values by largest to smallest. Am I missing something? Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I search for entries that are repeated in the workbook? | Excel Worksheet Functions | |||
| Printing text in a repeated cell/row that is longer than repeated | Excel Discussion (Misc queries) | |||
| Sort Legend Entries | Charts and Charting in Excel | |||
| Identify repeated cell entries in multiple sheet workbook as you . | Excel Discussion (Misc queries) | |||
| Filtering a column to exclude any repeated entries. | Excel Discussion (Misc queries) | |||
Linear Mode
