View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jesse Jesse is offline
external usenet poster
 
Posts: 35
Default I want my formulas to update when I sort the data, but they dont?

My problem is that I have huge list of data, and I create formulas to figure
averages, etc. Then, I want to sort the data and have my averages update
based on only what is shown by my sort. Can I do this