software

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.

Maybe...
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),quot;1quot;,quot;quot;)

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

--

Dave Peterson

One way to return the required quot;AAquot; to quot;IVquot; for copying across:
=CHAR(INT((COLUMN(A1)-1)/26) 65)amp;CHAR(MOD(COLUMN(A1)-1,26) 65)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Andrewquot; gt; wrote in message
...
gt; I have indirect formulaue in various cells that refer to certain columns
in a
gt; very large spreadsheet using the above formulae . The formulae above is
gt; pasted along row 1 and allows me to insert colums, drag and drop data etc
but
gt; still feed data into the solution. My problem is that after I reach column
Z
gt; the above formulae defaults to symbols and then to lower case letters
again.
gt; This does not work with my indirect formulae collecting info from columns
gt; after row Z. How can I change the above formulae to continue with letters
(?)
gt; after Z ? Any assistance appreciated.