Forum

Hi me again, formula works amazing job....question though how do I adjust the formula if I was to add 5 columns to the beginning of the information sh...

Purfleet.....yours worked up until tried to recreate the formulas to reference sheet2.

Thanks for all your help I will try these and see if they work with my actual data. Unfortunately the tabular format will not work as the 3x3 grid ...

Sorry about that..please see attached file