function for Column Position
 

Simply trying to modify equations (in columns) where long equation covers
column letter. Currently using row to designate column by hand, but when
cut-paste columns run into problems, just need to have same column Letter
Position re-displayed. Thanks...... currently have:

=CELL("COL",A67) gets a number, need column letter re-displayed

also: not familiar with arrays or vlookup, if answer & you have subject
info links
Thanks!....
-Nastech

function for Column Position
 

I don't quite get what you're doing, but you could use:


nastech wrote:

Simply trying to modify equations (in columns) where long equation covers
column letter. Currently using row to designate column by hand, but when
cut-paste columns run into problems, just need to have same column Letter
Position re-displayed. Thanks...... currently have:

=CELL("COL",A67) gets a number, need column letter re-displayed

also: not familiar with arrays or vlookup, if answer & you have subject
info links
Thanks!....
-Nastech

--

Dave Peterson

function for Column Position
 

Darn fingers...

=SUBSTITUTE(SUBSTITUTE(CELL("address",A1),"$",""), "1","")

Will return the column letter for A1.



nastech wrote:

Simply trying to modify equations (in columns) where long equation covers
column letter. Currently using row to designate column by hand, but when
cut-paste columns run into problems, just need to have same column Letter
Position re-displayed. Thanks...... currently have:

=CELL("COL",A67) gets a number, need column letter re-displayed

also: not familiar with arrays or vlookup, if answer & you have subject
info links
Thanks!....
-Nastech

--

Dave Peterson

function for Column Position
 

Hi, thanks... rolling on the floor (not at your darn fingers) because been
trying to figure that out... my darn fingers was the issue: once have
(many) long equations, past 1 line, "IT COVERS" the column letter you are
trying to work in. Suprised that MS can't think that far ahead. Anyways,
you cannot figure out what you were doing a few seconds ago. The problem:
when re-arranging columns, forget to change row of artificial column labels..
will never have to do that again.

Thanks!.. -nastech

"Dave Peterson" wrote:

Darn fingers...

=SUBSTITUTE(SUBSTITUTE(CELL("address",A1),"$",""), "1","")

Will return the column letter for A1.



nastech wrote:

Simply trying to modify equations (in columns) where long equation covers
column letter. Currently using row to designate column by hand, but when
cut-paste columns run into problems, just need to have same column Letter
Position re-displayed. Thanks...... currently have:

=CELL("COL",A67) gets a number, need column letter re-displayed

also: not familiar with arrays or vlookup, if answer & you have subject
info links
Thanks!....
-Nastech

--

Dave Peterson

function for Column Position
 

I'll either resize that window so the formulabar can't reach my stuff.

Or I'll turn off the formulabar.
View|Formula bar (to toggle it)

But you may like the way the new version will handle the formula bar.

http://blogs.msdn.com/excel/default.aspx
or directly:
http://blogs.msdn.com/excel/archive/2005/10/18.aspx

So MS is thinking about it <bg.

nastech wrote:

Hi, thanks... rolling on the floor (not at your darn fingers) because been
trying to figure that out... my darn fingers was the issue: once have
(many) long equations, past 1 line, "IT COVERS" the column letter you are
trying to work in. Suprised that MS can't think that far ahead. Anyways,
you cannot figure out what you were doing a few seconds ago. The problem:
when re-arranging columns, forget to change row of artificial column labels..
will never have to do that again.

Thanks!.. -nastech

"Dave Peterson" wrote:

Darn fingers...

=SUBSTITUTE(SUBSTITUTE(CELL("address",A1),"$",""), "1","")

Will return the column letter for A1.



nastech wrote:

Simply trying to modify equations (in columns) where long equation covers
column letter. Currently using row to designate column by hand, but when
cut-paste columns run into problems, just need to have same column Letter
Position re-displayed. Thanks...... currently have:

=CELL("COL",A67) gets a number, need column letter re-displayed

also: not familiar with arrays or vlookup, if answer & you have subject
info links
Thanks!....
-Nastech

--

Dave Peterson


--

Dave Peterson