You can use index to find the MIN and MAX runners
- Code: Select all
=INDEX(A5:A100,MATCH(MAX(F5:F100),F5:F100,0))
Obviously change the column from F to whatever column you want to check for the highest value F is just current back odds, but obviously you could use H for lay odds or O for last traded