software

Can column() return a letter instead of a number? I am planning to use
it with INDIRECT? Is that possible?

=INDIRECT(row() amp; column())?--
cKBoy
------------------------------------------------------------------------
cKBoy's Profile: www.excelforum.com/member.php...oamp;userid=31522
View this thread: www.excelforum.com/showthread...hreadid=512119
Hi
yes, it's possible, insert this into your formula:

CHAR(COLUMN() 64)

hth
Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=512119
Awesome! worked like a charm... Thanks! --
cKBoy
------------------------------------------------------------------------
cKBoy's Profile: www.excelforum.com/member.php...oamp;userid=31522
View this thread: www.excelforum.com/showthread...hreadid=512119
pleased I could help :-)
I hope the issue of columns greater than Z don't cause any problems...

Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=512119
oh, =INDIRECT(CHAR(COLUMN(E5) 64)amp;ROW()) worked, but what if I wanted to
get the cell from a different sheet but the same cell location? ie.
=INDIRECT(Sheet1.CHAR(COLUMN(E5) 64)amp;ROW()) -- but this didn't work, is
there something missing from the function?--
cKBoy
------------------------------------------------------------------------
cKBoy's Profile: www.excelforum.com/member.php...oamp;userid=31522
View this thread: www.excelforum.com/showthread...hreadid=512119if column gt;=AA?

so better

=LEFT(ADDRESS(1,COLUMN(),4),IF(COLUMN()lt;27,1,2))

-------
Ioannis, Athens
quot;cKBoyquot; wrote:

gt;
gt; Can column() return a letter instead of a number? I am planning to use
gt; it with INDIRECT? Is that possible?
gt;
gt; =INDIRECT(row() amp; column())?
gt;
gt;
gt; --
gt; cKBoy
gt; ------------------------------------------------------------------------
gt; cKBoy's Profile: www.excelforum.com/member.php...oamp;userid=31522
gt; View this thread: www.excelforum.com/showthread...hreadid=512119
gt;
gt;

It works only until column Z, if cKBoy needs two-letter column identifiers
(AA, AB, ...) as well, he should use

=LEFT(ADDRESS(1,COLUMN(),4,1),IF(CODE(MID(ADDRESS( 1,COLUMN(),4,1),2,1))gt;57,2,1))

Regards,
Stefi

„broro183” ezt �*rta:

gt;
gt; Hi
gt; yes, it's possible, insert this into your formula:
gt;
gt; CHAR(COLUMN() 64)
gt;
gt; hth
gt; Rob Brockett
gt; NZ
gt; Always learning amp; the best way to learn is to experience...
gt;
gt;
gt; --
gt; broro183
gt; ------------------------------------------------------------------------
gt; broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
gt; View this thread: www.excelforum.com/showthread...hreadid=512119
gt;
gt;

It's interesting why obvious solutions don't come up sometimes!
Stefi„ΓΙΑΝΝΗΣ Χ.Β.” ezt �*rta:

gt; if column gt;=AA?
gt;
gt; so better
gt;
gt; =LEFT(ADDRESS(1,COLUMN(),4),IF(COLUMN()lt;27,1,2))
gt;
gt; -------
gt; Ioannis, Athens
gt;
gt;
gt;
gt; quot;cKBoyquot; wrote:
gt;
gt; gt;
gt; gt; Can column() return a letter instead of a number? I am planning to use
gt; gt; it with INDIRECT? Is that possible?
gt; gt;
gt; gt; =INDIRECT(row() amp; column())?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; cKBoy
gt; gt; ------------------------------------------------------------------------
gt; gt; cKBoy's Profile: www.excelforum.com/member.php...oamp;userid=31522
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=512119
gt; gt;
gt; gt;

try
=INDIRECT(quot;sheet1!quot;amp;LEFT(ADDRESS(1,COLUMN(sheet1!E 5),4),IF(COLUMN(sheet1!E5)lt;27,1,2))amp;ROW(sheet1!E5) )
----
Ioannis, Athens

quot;cKBoyquot; wrote:

gt;
gt; oh, =INDIRECT(CHAR(COLUMN(E5) 64)amp;ROW()) worked, but what if I wanted to
gt; get the cell from a different sheet but the same cell location? ie.
gt; =INDIRECT(Sheet1.CHAR(COLUMN(E5) 64)amp;ROW()) -- but this didn't work, is
gt; there something missing from the function?
gt;
gt;
gt; --
gt; cKBoy
gt; ------------------------------------------------------------------------
gt; cKBoy's Profile: www.excelforum.com/member.php...oamp;userid=31522
gt; View this thread: www.excelforum.com/showthread...hreadid=512119
gt;
gt;

gt; =INDIRECT(Sheet1.CHAR(COLUMN(E5) 64)amp;ROW())

Try putting it as:
=INDIRECT(quot;'Sheet1'!quot;amp;CHAR(COLUMN(E5) 64)amp;ROW())
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---