Thread: avoid Descending Sort putting error cells uppermost in collumn
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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.
Reply With QuoteReply With Quote