C chg Dec 6, 2009 #1 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-
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 Dec 6, 2009 #2 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))
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))
