Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ordering a column by incidence
How can I order a column by the number of incidences of a value e.g. by the
number of times a name appears in that column, ordered by greatest to lowest. I apologise in advance if this is facile, but it's got me! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ordering a column by incidence
One way is to use
=countif(a:a,a2) and copy down. Then sort by that column -- Don Guillett Microsoft MVP Excel SalesAid Software "colensa" wrote in message ... How can I order a column by the number of incidences of a value e.g. by the number of times a name appears in that column, ordered by greatest to lowest. I apologise in advance if this is facile, but it's got me! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hard coded formula fix, VBA for column ordering | Excel Worksheet Functions | |||
ordering | Excel Discussion (Misc queries) | |||
Need help on formulating ordering | Excel Worksheet Functions | |||
Ordering Patterns | Excel Discussion (Misc queries) | |||
sorting/ordering a column by day of the week | Excel Discussion (Misc queries) |