Average top 100 using two conditions

[markw0411]

I have a set of data and I need to take the average of the top 100 values that meet two conditions. I am know I can use averageifs to find average based on multiple conditions and I can use average(large,row()) to find top 100. But how do I combine??

 

[Fennek]

Hello,

the "Autofilter" offers a top-n, with "visible Cells" or =aggregate() the average can be calculated

regards

 

[markw0411]

I apologize I do not understand where you are going with your recommendation. Attached is a portion of my data to better describe what I need to accomplish. Obviously there is a easy way to do this manual, but I am looking to automate as this is a big data set that is updated with new data monthly.

I need to average top 100 that have month = January and Site Status = Production

Month	Site Status	Unit A	Unit B	Unit C		Average Top 100
Jan	Production	1267	1765	3568		Unit	Jan	Feb
Jan	Production	1282	1741	3552		Unit A
Jan	Production	1362	1727	3543		Unit B
Jan	Production	1405	1739	3544		Unit C

<tbody>
</tbody>