I have the following formula in Column E:- =IF(AND(Results!$E$7=Selections!G7,Results!$F$7>0,Results!$F$7<=5.99),Data!$M$2,0) and need to copy it from Column E through to Column P
In Column F "Results!$E$7" needs to change to "Results!$E$8" and "Selections!G7" needs to change to "Selections!J8" and so on....
In other words "Results" is incrementing by "1" and "Selections" by 2 alpha
The formula is 14 lines long on a 24" wide screen monitor meaning a lot of work to do it manually column by column (tests 40 different variables)
Is there an easier way to do this!
HELP! HELP! HELP!
Cheers
Malawimick
Bookmarks