| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i perform calculations on filtered data
I have a long, two column list. I can sort the data easily with a pivot
table, but I want to summarize the data with a TRIMMEAN function. How do I reference the table's source data easily? Previously I have manually defined names for cell ranges and referenced those in my functions. but this is too laborious for the amount of data I now have. -Thanks for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| perform calculations in 2 sheets | Excel Worksheet Functions | |||
| How do I perform calculation on Filtered data | Excel Discussion (Misc queries) | |||
| perform calculations using time arguments | Excel Worksheet Functions | |||
| How to Perform Lookup on Alphanumeric Data? | Excel Discussion (Misc queries) | |||
| Best technique to perform multiple calculations ? | Excel Worksheet Functions | |||
Linear Mode
