View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
halg halg is offline
external usenet poster
 
Posts: 1
Default Sort on only portion of a column

Is it possible to only sort on a portion of a column rather than a whole
column? For example: cell A3 through A50 are values from calculated
formulas - cell A1 and A2 are column headings and cell A51 is a column total.
I only want to sort cells A3 - A50. I have tried several different ways,
but it always includes cell A51 in the sort. Please advise.