<div>
Hi,<br />
<br />
Could you create a short example in a new file to outline your thoughts<br />
<br />
Regards
</div>


Hi,

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

Regards

<div>
Thanks for your help. This ended up being the solution I used.
</div>


Thanks for your help. This ended up being the solution I used.

<div>
<div class="content wysiwyg-content">
I had this question after viewing <a href="https://www.experts-exchange.com/questions/28958861/Excel-Formula-Help-Benchmark-Subset-of-Array-Against-Another-Subset-in-Same-Array.html" rel="ugc">Excel Formula Help - Benchmark Subset of Array Against Another Subset in Same Array</a>.<br />
<br />
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.
</div>
</div>


I had this question after viewing Excel Formula Help - Benchmark Subset of Array Against Another Subset in Same Array (https://www.experts-exchange.com/questions/28958861/Excel-Formula-Help-Benchmark-Subset-of-Array-Against-Another-Subset-in-Same-Array.html).

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.

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.