matt-gilbert
Member
Hi all,
I have a spreadsheet (attached) where I record lotto number selections and results. I would like to modify a couple of formulas as follows;
Column K - I currently have to manually adjust each week to change lookup range of results eg in cell K3 it refers to C$17:I$17. Formula would need to use column A (date) and column B ("Results") to reference C$17:I$17.
Column L - Similar to above but lookup range is only one column ie column J.
Also, was hoping to add a conditional format to highlight matching numbers. I can do this when there is only one "Results" range however am having trouble now due to multiple "Results" ranges on same sheet. Was hoping to have just two conditions for entire sheet rather than separate conditions for each week ie (1) standard numbers 1-7 and (2) Powerball.
Any other changes to formulas would be welcomed too...I know they're not the most elegant and may be memory hungry as sheet gets bigger.
Thanks in advance.
Matt
I have a spreadsheet (attached) where I record lotto number selections and results. I would like to modify a couple of formulas as follows;
Column K - I currently have to manually adjust each week to change lookup range of results eg in cell K3 it refers to C$17:I$17. Formula would need to use column A (date) and column B ("Results") to reference C$17:I$17.
Column L - Similar to above but lookup range is only one column ie column J.
Also, was hoping to add a conditional format to highlight matching numbers. I can do this when there is only one "Results" range however am having trouble now due to multiple "Results" ranges on same sheet. Was hoping to have just two conditions for entire sheet rather than separate conditions for each week ie (1) standard numbers 1-7 and (2) Powerball.
Any other changes to formulas would be welcomed too...I know they're not the most elegant and may be memory hungry as sheet gets bigger.
Thanks in advance.
Matt