| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting: cleared/null v/s ""
On Nov 26, 3:32*pm, wrote:
Cate You could possibly add an additional column, with an IF formula that equals the intended sort column, unless the sort column is blank or null or otherwise problematic, in which case the formula returns ZZZ or something that will sort as you wish; then sort by the new column. Ken On Sunday, November 25, 2012 11:49:52 AM UTC-5, cate wrote: It looks like I'm dead - no go. *The new question is then: is there a sort configuration that say empties last? (nulls last) Thank you for any suggestions. Good idea. Thank you Ken. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting a text strings but omitting preceding "A" or "The" | Excel Worksheet Functions | |||
| sheet protected but cells "cleared of all" become locked | Excel Discussion (Misc queries) | |||
| Null, "null", vbNull, vbNullString, vbEmpty | Excel Programming | |||
| cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) | |||
| "IF"- "THEN" type Formula based on Null value | Excel Worksheet Functions | |||
Threaded Mode
