Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort column beginning with blank?
Want to sort a column by number. Numbers unclude blanks, then, 0-9.
Need to sort the column beginning with the blank, then from 0 through 9. (So, blank comes before zero.) Is there a way to do this? TIA for any ideas. Pete |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort column beginning with blank?
Came up with an answer:
I created a helper column; and any value that should return a blank, instead obtains a value of -.5 (negative point 5). Then sort, so that it would show up on the proper sort order. Using conditional formatting to display any value less than zero in a white font, in effect displays the blank. Thanks for any thought put into this. Pete On Tuesday, October 30, 2012 8:27:15 AM UTC-5, Pete wrote: Want to sort a column by number. Numbers unclude blanks, then, 0-9. Need to sort the column beginning with the blank, then from 0 through 9. (So, blank comes before zero.) Is there a way to do this? TIA for any ideas. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add Charaters to the beginning of a column of numbers. | Excel Programming | |||
Count equal numbers in beginning of a column | Excel Programming | |||
Sort beginning one-line BELOW what should be | Excel Programming | |||
need enter key to move to the next column beginning | Excel Worksheet Functions | |||
Add a alphabetic character to the beginning of an entire column of | Excel Discussion (Misc queries) |