Quote Originally Posted by martindwilson View Post
trouble with column() is you have to adjust it
so if you are in col g it will return 7 so to get 2 you have to use column()-5
a bit of a pain really and would put the formula out if you inserted a column in the wrong place
martindwilson,
Absolutely, I agree! Hence the warning at the bottom of my post.

pfchang,
I have to defer to the Forum Guru on this, his solution is clearly more robust than mine. But now we have both learnt something