Hi All again another problem
I have a large data base and to save time I need to get an infill for the highest number
within a set line.I can do fill in each race but that takes time hopeing you can tell me how to do it.
In column 2 from zero down to the next zero i'd like to put the highest number in column3 filled down in column 4 till the next zero
then the highest number from the next zero to next and so on.
Column1 Column2 Column3 Column4
Pontefract 0 73 75
Pontefract 0.05 72 75
Pontefract 6.65 66 75
Pontefract 6.55 75 75
Pontefract 8.9 69 75
Pontefract 2.55 73 75
Pontefract 6.05 72 75
Pontefract 46.9 49 75
Pontefract 0 79 86
Pontefract 2.02 82 86
Pontefract 0.5 82 86
Pontefract 1.25 80 86
Pontefract 2 84 86
Pontefract 9.02 86 86
Pontefract 17.02 77 86
Pontefract 38.02 74 86
Pontefract 0 60
Pontefract 0.1 64
Pontefract 6.1 61 66
Pontefract 5.1 61
Pontefract 19.1 66
Ascot 0 81 84
Ascot 15.37 79
Ascot 12.1 77
Ascot 5 78
Ascot 4.9 83
Ascot 12.6 78
Ascot 0.5 84
Ascot 15.35 83
Ascot 0 76 85
Ascot 2 77
Ascot 2.75 85
Ascot 4.75 80
Ascot 3.5 78
Ascot 4 77
Ascot 6.87 85
Ascot 14.85 77
Ascot 28.87 83
Ascot 32 77
Ascot 33.87 83
I hope that explains it all fingers crossed
I have a large data base and to save time I need to get an infill for the highest number
within a set line.I can do fill in each race but that takes time hopeing you can tell me how to do it.
In column 2 from zero down to the next zero i'd like to put the highest number in column3 filled down in column 4 till the next zero
then the highest number from the next zero to next and so on.
Column1 Column2 Column3 Column4
Pontefract 0 73 75
Pontefract 0.05 72 75
Pontefract 6.65 66 75
Pontefract 6.55 75 75
Pontefract 8.9 69 75
Pontefract 2.55 73 75
Pontefract 6.05 72 75
Pontefract 46.9 49 75
Pontefract 0 79 86
Pontefract 2.02 82 86
Pontefract 0.5 82 86
Pontefract 1.25 80 86
Pontefract 2 84 86
Pontefract 9.02 86 86
Pontefract 17.02 77 86
Pontefract 38.02 74 86
Pontefract 0 60
Pontefract 0.1 64
Pontefract 6.1 61 66
Pontefract 5.1 61
Pontefract 19.1 66
Ascot 0 81 84
Ascot 15.37 79
Ascot 12.1 77
Ascot 5 78
Ascot 4.9 83
Ascot 12.6 78
Ascot 0.5 84
Ascot 15.35 83
Ascot 0 76 85
Ascot 2 77
Ascot 2.75 85
Ascot 4.75 80
Ascot 3.5 78
Ascot 4 77
Ascot 6.87 85
Ascot 14.85 77
Ascot 28.87 83
Ascot 32 77
Ascot 33.87 83
I hope that explains it all fingers crossed