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

How do I have a cell value define a dynamic named range? 15
Dependent drop down dynamic range formula, off sheet. 7
Conditional formatting on a dynamic range - workaround 1
Dynamic Named Ranges 3
Constructing Range Name calls with Concatenate 4
a data validation list that contains a list of named ranges - not alist from a named range 1
Dynamic Named Range formula without using OFFSET function 5
Refer to a named range indirectly 2

Top