Data range to names

  • Thread starter Thread starter Erik B
  • Start date Start date
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
 
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
 
Hi

=CHOOSE(MATCH(A1,{-99999;1;4;7;10},1),"","left","midle","right","")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set non-continuous PrintArea via Function / Name 0
VBA - retrieve data on last create named range from previous inserted named range 0
Dynamic Named Ranges 3
using indirect to return a named range? 1
Go To a Named Range (2nd posting) 4
Conditional formatting on a dynamic range - workaround 1
a data validation list that contains a list of named ranges - not alist from a named range 1
data validation using named range from another file 3

Back
Top