| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
avoid Descending Sort putting error cells uppermost in collumn
Hi, have collumns with numerical results but also error cells which appear
blank due to the formula: =IF(ISERROR((GD17-FE17)/2),"",(GD17-FE17)/2) being applied. When I sort on `desending order` I want the highest numerical results at top of collumns and the error (BLANK) cells at the bottom. Any suggestions Guys? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Putting subtotals in $ descending order | Excel Worksheet Functions | |||
| Ascending Sort formula, change to neg #: descending sort.. | Excel Discussion (Misc queries) | |||
| sort alpa descending 'cell size' error | Excel Worksheet Functions | |||
| Sort cells with same text descending | Excel Discussion (Misc queries) | |||
| how can I hide sort ascending and sort descending options in the . | Excel Discussion (Misc queries) | |||
Threaded Mode
