• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

How do I create dynamic names with text in Excel?

Hello everyone

How do I create dynamic names for text? I asked a similar question before which worked very well with numbers/dates only.

Thanks,
Massimo

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27400333.html
0
Massimo Scola
Asked:
Massimo Scola
1 Solution
 
barry houdiniCommented:
In this formula

=Date!$A$2:INDEX(Date!$A:$A,MATCH(10^10,Date!$A:$A))

10^10 is used to find the last date (or number) for text change that to REPT("z",255), i.e.

=Date!$A$2:INDEX(Date!$A:$A,MATCH(REPT("z",255),Date!$A:$A))

to find the last text value....and define the range using that

regards, barry

0
 
Massimo ScolaAuthor Commented:
Great!

Thanks Barry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now