How to sort, based upon the length of the data ?

  • Thread starter Thread starter Mark246
  • Start date Start date
M

Mark246

I LOVE This Forum. You people are Terrific !

In Excel 2007,
How can I sort the data in a column,
so that the SHORTEST pieces of data come out on top? Like...
a
k
z
aa
dd
ccccc
bbbbbbbb

Thanks very much, people.

Mark246
 
You will need a helper column (a blank column adjacent to the data).
In the top cell enter = Len(A2) and fill down.
(assumes your data starts in cell A2)
Sort using the new column as the key column and the original column as
the secondary sort column.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins... two dozen ways to sort with Special Sort)



in message
I LOVE This Forum. You people are Terrific !

In Excel 2007,
How can I sort the data in a column,
so that the SHORTEST pieces of data come out on top? Like...
a
k
z
aa
dd
ccccc
bbbbbbbb

Thanks very much, people.

Mark246
 
Back
Top