E
Erik B
How do I give a name to a data range?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Govier
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
Insert>Name>Define 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
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
Insert>Name>Define 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
E
Erik B
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
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
A
Arvi Laanemets
Hi
=CHOOSE(MATCH(A1,{-99999;1;4;7;10},1),"","left","midle","right","")
=CHOOSE(MATCH(A1,{-99999;1;4;7;10},1),"","left","midle","right","")