Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to take average from column range matching another
I am trying to write a formula that returns a calculation, lets say an
average, of a range of numbers down a column that match up with a value in another column. In the example below, I have multiple occurances of a certain number study in a long list of studies that have values associated with them in another column. If I run a pivot table to get one row per study, can I write a formula (to the right, outside the pivot table) to go to my data table and return the average for all Values in Study 1, 2 and so on? Study Value 1 2 1 4 2 3 2 6 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date formulas | Excel Discussion (Misc queries) | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Need to average a range AND calc a formula at once... | Excel Worksheet Functions | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) |