| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sort, based upon the length of the data ?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sort, based upon the length of the data ?
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) "Mark246" wrote 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort column data regardless of col length | Excel Worksheet Functions | |||
| Sort a range of data based on another column | Excel Discussion (Misc queries) | |||
| Sort text list by character length - how? | Excel Worksheet Functions | |||
| How do I sort a large column of data by length? | Excel Worksheet Functions | |||
| How do I get a pivot table to sort based on the data items sectio. | Excel Worksheet Functions | |||
Hybrid Mode
