Create a list of Min values from data table

Originally Posted by XOR LX

@Fotis

Not sure I agree with your logic there. How do you know that a given time doesn't match in the first choice of indexed columns, but for a completely different race/driver?

Me too! It was Friday evening(21:00pm) when i posted my last reply...

So my opinion is that these INDEX & MATCH formula don't give the correct result because they try to match only the faster time and not the venue AND the faster time!! This ARRAY entered formula does this.

=IFERROR(INDEX('Race Data'!$I$2:$I$100;MATCH($C2&$D2;'Race Data'!$E$2:$E$100&'Race Data'!$N$2:$N$100;0));INDEX('Race Data'!$I$2:$I$100;MATCH($C2&$D2;'Race Data'!$E$2:$E$100&'Race Data'!$O$2:$O$100;0)))

This formula gives almost same results as the first one EXCEPT of 1 result which proove that first formula was not correct. Look the results for AVUS venue and compare the results..

..As their are only a few Races at Indianapolis I just add the pole time to the race time, so their are no blank values. I can make any modification later.

@ Jim

Min(if formula takes the empty cells like zeros values and gives 0 as result. I modified a little the formula(adding 1 more if) and now works fine!

=MIN(IF('Race Data'!$E$2:$E$1000=C2;IF('Race Data'!$N$2:$O$1000<>"";'Race Data'!$N$2:$O$1000)))