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.

Attached Files

Copy of Betfair Date.xls (396.5 KB, 1049 views)

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

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

You could conditional format to high light the Fav