Excel Help

[Shaun]

Hi, i have some betfair data that i wanted to sort.

What i have is some code in the shaded area that separates racing win markets and indicates the winner, what i need is a way to show the fav in each of those markets some sort of code i can copy down in a cell.


I have only uploaded part of the files as it is very large.

[Crackone]

this will find the lowest price =MIN(IF($C$2:$C$6000=C2,$J$2:$J$6000,"")) enter with shift control enter, also you could expand the range.

Its a start

[Crackone]

You could conditional format to high light the Fav