G
Guest
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
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