ordering a column by incidence

C

colensa

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!
 
N

NBVC

add a helper and apply a Countif()

=Countif(A:A,A1) copied down where column A contains the items and A1
is the first item... adjust as necessary...

then sort by this column


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
 

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

Insert Index into a Table 1
Counting multiple occcurrences between date range 3
Merging from an Excel file with graphics 1
Vlookup challenge 11
Relationship Help - Problem and Incident Database 1
Word VBA - Automatic change content of a cell in table using dropdown list 5
Autonumber field in Excel that behaves the same as Access 0
Function in Excel to count and list number of entries of text valuesin a row. 2

Top