[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 60
  • Last Modified:

Take average of differences between two subsets in same array, not just difference between two averages

I had this question after viewing Excel Formula Help - Benchmark Subset of Array Against Another Subset in Same Array.

I have a data set in dynamic array form that includes YYYYQ, MSA name plus national data, and value. I would like average quarterly differences between each MSA and national market value without using VBA. This is not taking the average of each then subtracting one from another, but rather calculating each difference then averaging the quarterly differences.
0
dhansen_
Asked:
dhansen_
1 Solution
 
Rgonzo1971Commented:
Hi,

Could you create a short example in a new file to outline your thoughts

Regards
0
 
Brian BIndependant Technology ProfessionalCommented:
Spelling out how it would work as above will help, But meanwhile, it sounds like you need an array formula with the average of the difference of the two arrays. Something like this:

average({array1-array2})
0
 
dhansen_Author Commented:
Thanks for your help. This ended up being the solution I used.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now