Hi all, Here is a sample of a spreadsheet (horse racing).
A B C D E F G
[TABLE="width: 590"]
<tbody>[TR]
[TD]13:35[/TD]
[TD]Lismore[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]Flag Raiser[/TD]
[TD]73.60[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13:35[/TD]
[TD]Lismore[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]Game Set Match[/TD]
[TD]64.46[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13:50[/TD]
[TD]Goulburn[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]Acquittal[/TD]
[TD]66.63[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13:50[/TD]
[TD]Goulburn[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]Rubino Veloce[/TD]
[TD]63.66[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:45[/TD]
[TD]Lismore[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]Angels Of Fenway[/TD]
[TD]64.09[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:45[/TD]
[TD]Lismore[/TD]
[TD]4[/TD]
[TD]8[/TD]
[TD]Tis Toby[/TD]
[TD]52.77[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
A B C D E F G
[TABLE="width: 590"]
<tbody>[TR]
[TD]13:35[/TD]
[TD]Lismore[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]Flag Raiser[/TD]
[TD]73.60[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13:35[/TD]
[TD]Lismore[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]Game Set Match[/TD]
[TD]64.46[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13:50[/TD]
[TD]Goulburn[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]Acquittal[/TD]
[TD]66.63[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13:50[/TD]
[TD]Goulburn[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]Rubino Veloce[/TD]
[TD]63.66[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:45[/TD]
[TD]Lismore[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]Angels Of Fenway[/TD]
[TD]64.09[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:45[/TD]
[TD]Lismore[/TD]
[TD]4[/TD]
[TD]8[/TD]
[TD]Tis Toby[/TD]
[TD]52.77[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
Last edited: