Whilst your formula works perfectly for the question I asked (Gary I think
yours gives me the column number not the value of the cell contents) I just
realised it doesn't always solve my problem. Thank you for your responses
though. It keeps astounding me how little of excel I actually use.
I will explain my problem better. What I have is a range in L5 going right
consisting of lap time, place in race, next lap time, place in race etc. So
like this
0:32:23 3 1:00:12 2 1:32:14 1
What I am trying to determine using a formula in k5 is the last time in the
row, which will always be the max time and always 2nd column from the right
hand end. The number of laps completed can vary between races though so i
can't just refer to a set cell.
I'm sorry I wasted your time before but is there a way using formula I can
come up with the time value from the second last cell. In this example 1:32:14
Thanks again.