Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |