Average of 5 minimum values in a dynamic number of rows

Hi,

 

I have a unique values in column A and related times for each of the unique value in column B. The times recorded for the unique values may vary (could be either 1 time recorded or could be 25 separate times recorded for the same unique value). 

I want to calculate the average of the 5 minimum times recorded for every unique value. Please note that if the time recorded is just once, then the average for the 5 minimum times will just be that recorded number itself – basically for 5 or less values, it will just be a regular average.

 

Can someone please help me with a dynamic formula that could be applied here?

 

Thanks

By: Faeeza

Leave a Reply

Your email address will not be published. Required fields are marked *