[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • 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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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