Solved

# How do I create dynamic names with text in Excel?

Posted on 2011-10-21
194 Views
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
Question by:mscola

LVL 50

Accepted Solution

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

Author Closing Comment

Great!

Thanks Barry
0

## Featured Post

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.