Macro to find last entry on sheet and result .

[I need excel help]

Hello all ,

The results I am needing are in col G . Col AH are in ascending order .

I have a sheet with 490,000 rows , this grows weekly so speed is important if possible .

Col BH is where the results will be sourced from .

I need to find the last data entry of each horse , then look at col BH and put a T in col G but
only for this entire cam# number .

When the next number above decreases put L in col G .
When the next number above decreases put 3 in col G .
When the next number above decreases put 4 in col G .
When the next number above decreases put 5 in col G .
When the next number above decreases put 6 in col G . Etc .

Cam# can run into 40 or 50 for some .

"A good example is horse named A Sherry For Mary , its last 5 x starts all have a different cam# , so result is L T 3 4 5 . And so on until it reaches cam# 1 . Being 12 result .
"
Hope this is do able .

Thanks .

[I need excel help]

If it makes any easier L can be result 1 and T result 2 , then 3 4 5 6 7 8 etc .
Thanks .

[nilem]

Hi,
try this

Please Login or Register  to view this content.

[I need excel help]

Great , i have only tested once and will do another but the speed is perfect and 100% accurate .
It was late when i ran it over 490,000 rows but im sure it only took a few minutes .
Thank you so much nilem .