Hi I need help with a formula I am creating.
I want to calculate the average speed given in b2:n2 of the 7 machines that have started the earliest, based on the starttime given in b3:n3.
I have tried =Average(IF(X36:AJ36<Average(X36:AJ36);X35:AJ35;"")) but when the starttime values are too close together or have major outliers this does not work.
I have attached a testfile.
Many thanks in advance!
Bookmarks