Thread: avoid Descending Sort putting error cells uppermost in collumn
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Romileyrunner1 Romileyrunner1 is offline
external usenet poster
  
Posts: 73
Default 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.
Reply With QuoteReply With Quote