Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I'm using MS Office Excel 2003. I'd like to be able to refer to a column by
a name so that I could use 'Price'23 instead of C23 and so forth. I thought that I'd be able to do that by highlighting the column and then using Insert-Name-Define or similar (I can't figure out the difference between the Name-Create, Name-Define and Name-Label variations. In any case, none of them seem to allow the kind of construction I'd like. Do I have the syntax wrong in Price23 (for example ... how to separate column and row parts) or is the whole thing impossible? Cheers, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF using # ranges, and referencing 2 other columns | Excel Worksheet Functions | |||
compare two columns with different ranges in two worksheets | Excel Discussion (Misc queries) | |||
IF ranges for multiple columns greater then less then | Excel Worksheet Functions | |||
formula to show ranges in columns | Excel Worksheet Functions | |||
ranges and columns | Excel Discussion (Misc queries) |