Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Sort sequence rules place blank cells at the end of both ascending and
descending sorts which is what I want. However, cells that contain "" are sorted before numbers in descending sorts, which I don't want. I create a conditional formula to test for division by a cell that is blank, if true, I want the result to be a true blank cell, not a cell with "". Is there a special character code or function that I can use to accomplish this? I'm using Excel 2002. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Format to highlight blank cell | Excel Worksheet Functions | |||
blank cell turns to 0 | New Users to Excel | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
conditional formatting blank cell | Excel Discussion (Misc queries) |