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)
 
Top