Insert > Name > Define

C

Chris Johnson

Why does this work for a Name definition of a range?

=Sheet1!$A$3:INDEX(DataforCharts!$A:$A,MATCH(9.99999E+307,DataforCharts!$A:$A))

It works but I can't figure out why. The INDEX returns the value of the
last cell with data in it, however if I just replace all of that with the
value it does not work anymore. For example this does NOT work.

=Sheet1!$A$3:40857
 
D

Dave Peterson

Actually, this portion:

=MATCH(9.99999E+307,DataforCharts!$A:$A)

returns the last row in column A of the DataForCharts worksheet that has numeric
data in it.


But you didn't translate the =index() portion. That would include the column
reference, too.
Essentially:

=Sheet1!$A$3:A40857
 

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

Visio: copy text of a master shape to User-define Cells (Variable) 0
Insert Index into a Table 1
Need Help with a VBA subroutine 0
Setting column width in a table with a macro is not working 0
Document Merge Formatting Issue 0
Read Only now different 1
One note creating multiple tabs when collaborating? 0
MS Project - error message when checking "Critical tasks" 1

Top