Notifications
Clear all
Topic starter
Say, for number 3, we know column name is C or for number 27, column name is AA. Is there any smart way to get to know the column number for any number provided?
Posted : 06/08/2016 9:50 pm
You could try this
=SUBSTITUTE(ADDRESS(1,<your column number>,4),"1","")
Posted : 06/08/2016 10:37 pm
Topic starter
Bang on Sunny! Brilliant!
Posted : 07/08/2016 3:30 am
