View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default Sort a list with a formula

you could use LARGE or SMALL but why?

--
Don Guillett
SalesAid Software

"Steve-in-austin" wrote in message
...
Is there a way to sort a column with a series of formulas? ie select the
range and return the lowest value in row 1, next value in row 2 etc. The
range may contain blanks, which should sort to the bottom.
Thanks in advance!