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?