| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
avoid Descending Sort putting error cells uppermost in collumn
=IF(ISERROR((GD17-FE17)/2),-999999,(GD17-FE17)/2)
or any other very large negative value -- Gary''s Student - gsnu200901 "Romileyrunner1" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
avoid Descending Sort putting error cells uppermost in collumn
Great works fine: Thanks Gary`s Student!
I`m using just -999 which is small enough. But how do I use conditional formatting to `white-out` the text for those cells I`ve tried <900 and =-999 as conditions, But they don`t seem to work? Any ideas about this? Thanks. "Gary''s Student" wrote: =IF(ISERROR((GD17-FE17)/2),-999999,(GD17-FE17)/2) or any other very large negative value -- Gary''s Student - gsnu200901 "Romileyrunner1" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
avoid Descending Sort putting error cells uppermost in collumn
Hey, no need to reply: just found out what I was doing wrong
I already had another condition running <3 (to turn pink) and this was obviously conflicting with the <900 or indeed =-999 commands . Perhaps I need to take a break!!!!! Thanks anyhow. "Romileyrunner1" wrote: Great works fine: Thanks Gary`s Student! I`m using just -999 which is small enough. But how do I use conditional formatting to `white-out` the text for those cells I`ve tried <900 and =-999 as conditions, But they don`t seem to work? Any ideas about this? Thanks. "Gary''s Student" wrote: =IF(ISERROR((GD17-FE17)/2),-999999,(GD17-FE17)/2) or any other very large negative value -- Gary''s Student - gsnu200901 "Romileyrunner1" wrote: 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. |
| Reply |
| 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) | |||
Linear Mode
