LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default Name ranges and columns

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF using # ranges, and referencing 2 other columns crafty_girl Excel Worksheet Functions 0 April 27th 06 07:23 PM
compare two columns with different ranges in two worksheets ch90 Excel Discussion (Misc queries) 2 October 14th 05 02:13 PM
IF ranges for multiple columns greater then less then Soccer_Ref Excel Worksheet Functions 3 August 27th 05 10:13 PM
formula to show ranges in columns Lori Excel Worksheet Functions 7 May 23rd 05 12:44 PM
ranges and columns Kevin Excel Discussion (Misc queries) 3 February 14th 05 08:34 AM


All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"