Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want my formulas to update when I sort the data, but they dont?
On Nov 14, 12:12*pm, Jesse wrote:
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 Sort doesn't change what is shown, just the order, so your calcs shouldn't change. Do you mean you are filtering? Or should be filtering? Use the SUBTOTAL function to show calculations for only the visible (filtered) items. Read up on it in Help for how to use it for sum, average, count, etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when i select dont update I get #REF! | Excel Discussion (Misc queries) | |||
Save file with different name and dont update the links when opened again | Excel Discussion (Misc queries) | |||
Save file with different name and dont update the links when opened again | Excel Discussion (Misc queries) | |||
Save file with different name and dont update the links when opened again | Excel Discussion (Misc queries) | |||
get date with now() today() but dont update with recalc | Excel Worksheet Functions |