Help with a macro to check results and highlight future forecasts

[khanaran]

Hi to all

I am doing a little exercise e manually with the results from the lotto 649 and attempt to calculate a forecast for the next draw or next few draws.

I attach a file with the table and also a brief explanation of what I would like to accomplish with a macro to automate the process I do manually

I thank you in advance for help wit a macro and or advice.


Kind regards

Raj