Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Note that the above logic is only efficient when the character count in
the target columns is stable. For example, if a column holds only five characters, it will be efficient. If it holds 5 and 6 character values, it will not be consistent in its sort. Stable items would include phone number, social security numbers, account numbers. Dates, money and names have the potential of being unstable. Good Luck xlsweetspot |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I sort columns by colors, example - red, green, yellow | Excel Discussion (Misc queries) | |||
Group and sort on two columns | Excel Discussion (Misc queries) | |||
Organize and sort columns | Excel Discussion (Misc queries) | |||
DATE SORT BY COLUMNS | Excel Worksheet Functions | |||
ALLOW ROW 1 AS HEADER ROW... NOT PART OF DATA SORT OF ANY COLUMNS. | New Users to Excel |