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- |
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- |
Defind Dynamic named Range up to first error
Thx alot, works pretty, pretty good!
|
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! |
All times are GMT +1. The time now is 01:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com