• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 62
  • 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 BEE Topic Advisor, Independant 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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