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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks