Morning All,

I have been trying to get this work all morning and when i thought i had done it.. i got a new problem! I have the same highest number in a range of data, which looks up the row above.

Is it possible for a formula to ignore the first highest number?

Book2.xlsx

Sorry is this sounds complicated, any help on this would be awesome!

Thanks