Question regarding : CHAR(64+COLUMN())
I have indirect formulaue in various cells that refer to certain columns in a
very large spreadsheet using the above formulae . The formulae above is
pasted along row 1 and allows me to insert colums, drag and drop data etc but
still feed data into the solution. My problem is that after I reach column Z
the above formulae defaults to symbols and then to lower case letters again.
This does not work with my indirect formulae collecting info from columns
after row Z. How can I change the above formulae to continue with letters (?)
after Z ? Any assistance appreciated.
|