Difference between 2 values

[Pauls123]

Hi all, Here is a sample of a spreadsheet (horse racing).

A B C D E F G

13:35	Lismore	2	2	Flag Raiser	73.60	1
13:35	Lismore	2	1	Game Set Match	64.46	2
13:50	Goulburn	2	1	Acquittal	66.63	1
13:50	Goulburn	2	4	Rubino Veloce	63.66	2
14:45	Lismore	4	3	Angels Of Fenway	64.09	1
14:45	Lismore	4	8	Tis Toby	52.77	2

<tbody>
</tbody>

I need to know the difference that F1 is greater than F2, then F3 is greater than F4, then F5 is greater than F6, and so on. At the end of this I will use Conditional Formatting to arrive at the one with the greatest value (difference).

Any thoughts,?

Thanks, Paul, Australia

 

[footoo]

=if(g1=1,f1-f2,"")

 

[Pauls123]

Hi footoo, Brilliant, excellent, just what I wanted.

Thank you
Paul, down in Australia