Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data range to names
How do I give a name to a data range? -- Erik B ------------------------------------------------------------------------ Erik B's Profile: http://www.excelforum.com/member.php...o&userid=27621 View this thread: http://www.excelforum.com/showthread...hreadid=471681 |
#2
|
|||
|
|||
Hi Erik
Either Mark the range of data, go to the white pane to the left of column letter A and above Row 1, type in the name you wish to use, press Enter. Or InsertNameDefine and in the Name pane Enter name required, and in the Refers to pane enter =$A$1:$D$50 or whatever your range is to be. Regards Roger Govier Erik B wrote: How do I give a name to a data range? |
#3
|
|||
|
|||
Yes I know that, but i mean something else Example: 1 to 3 Excel has to say left 3 to 6 Excel has to say middle 6 to 9 Excel has to say right And when I change a value the name has to change too. -- Erik B ------------------------------------------------------------------------ Erik B's Profile: http://www.excelforum.com/member.php...o&userid=27621 View this thread: http://www.excelforum.com/showthread...hreadid=471681 |
#4
|
|||
|
|||
Hi
=CHOOSE(MATCH(A1,{-99999;1;4;7;10},1),"","left","midle","right","") -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "Erik B" wrote in message ... Yes I know that, but i mean something else Example: 1 to 3 Excel has to say left 3 to 6 Excel has to say middle 6 to 9 Excel has to say right And when I change a value the name has to change too. -- Erik B ------------------------------------------------------------------------ Erik B's Profile: http://www.excelforum.com/member.php...o&userid=27621 View this thread: http://www.excelforum.com/showthread...hreadid=471681 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Range Mess | Charts and Charting in Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Help! Selecting data according to date range | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |