| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Defind Dynamic named Range up to first error
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- |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Defind Dynamic named Range up to first error
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)) -- Biff Microsoft Excel MVP "chg" wrote in message ... 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- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Defind Dynamic named Range up to first error
Thx alot, works pretty, pretty good!
|
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Defind Dynamic named Range up to first error
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "chg" wrote in message ... Thx alot, works pretty, pretty good! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Named Range | Excel Discussion (Misc queries) | |||
| How to make a dynamic named range | Excel Discussion (Misc queries) | |||
| Dynamic Named Range | Excel Discussion (Misc queries) | |||
| #value! error trying to create a simple dynamic named range | Excel Discussion (Misc queries) | |||
| Dynamic Named Range | Charts and Charting in Excel | |||
Linear Mode
