View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
newbie newbie is offline
external usenet poster
 
Posts: 137
Default Sorting data derived from formula

I need to sort a total column that was created from adding up other cells.
Where I run into a problem is that I need the whole row to go with it when it
does sort. Each row has a name, three column boxes of data, then a total
that was created by using a sum function. I want to sort by the total but
keep everything in tact. I know it seems quite elementary, but I can't seem
to find a way to make this work. Any help? Thanks.