Excel Formula

[jdaley1980]

I'm trying to find a formula that will find my fastest average time for my runs that are greater than 2 mile then show the date. I've attached an example excel sheet

http://files.engineering.com/getfil...7-9ac4-4152-ba1f-d07f6f3005a8&file=Book1.xlsx

 

[SkipVought]

Hi,

Sort your lookup table by Miles ascending.

Use the MATCH() function with Match Type of 1 in your results table.

I use Named Ranges

=INDEX(INDIRECT(J$8),MATCH($I9,miles,1),1)

I'm assuming that your results table begins at I7

 

[kjv1611]

One of these days I'll remember the INDEX/INDIRECT/MATCH usage well like Skip.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[SkipVought]

Oops table begins at I8