Defind Dynamic named Range up to first error

C

chg

I want to define a named Range up to the first cell in a column that
has a #value error.
How could i find that cell?
Any ideas

Thx-
 
T

T. Valko

Do you want to include that cell in the range?

Are there any other types of errors in the range like #N/A, #NUM!, #DIV/0! ?

Try something like this:

=Sheet1!$A$1:INDEX(Sheet1!$A:$A,MATCH(TRUE,ISERROR(Sheet1!$A$1:$A$20),0))
 

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

Excel does not accept text format! 0
Merging from an Excel file with graphics 1
Dynamic Named Ranges 3
Constructing Range Name calls with Concatenate 4
How do I have a cell value define a dynamic named range? 15
Check Dynamic Named Range 5
Need Help with a VBA subroutine 0
Setting a range in a named range 3

Top