Hi Steve,
One Final Question Please,
I am Using the Formulas …
Q2 ="$J$" & COLUMN()-14 & ":$O$" & COLUMN()-14
Q3 =COUNT(MATCH(INDIRECT(Q$2),$C3:$H3,0))
… and they Work Great.
However, I Inserted 5 Extra Lines at the Top of the Sheet and the
Formula ="$J$" & COLUMN()-14 & ":$O$" & COLUMN()-14 Doesn't Seem to Work
Anymore. I have Tried Changing Different things But to NO Avail.
Thanks in Advance.
All the Best.
Paul
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!