PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Ignoring error msg

Reply

Ignoring error msg
 
Thread Tools Rate Thread
Old 20-11-2003, 11:22 AM   #1
Phil Hageman
Guest
 
Posts: n/a
Default Ignoring error msg


Is there a way to make this array formula ignore and error
message in a cell in the range?

{=INDIRECT(ADDRESS(MAX((ROW(19:30)*
(X19:X30<>""))),COLUMN(X:X)))}
  Reply With Quote
Old 20-11-2003, 01:51 PM   #2
Peo Sjoblom
Guest
 
Posts: n/a
Default Re: Ignoring error msg
One possible way

=INDIRECT(ADDRESS(MAX(IF(ISNUMBER(ROW(19:30)*(X19:X30<>"")),ROW(19:30)*(X19:
X30<>""))),COLUMN(X:X)))

array entered

--

Regards,

Peo Sjoblom


"Phil Hageman" <anonymous@discussions.microsoft.com> wrote in message
news:23a501c3af58$8585d7f0$a601280a@phx.gbl...
> Is there a way to make this array formula ignore and error
> message in a cell in the range?
>
> {=INDIRECT(ADDRESS(MAX((ROW(19:30)*
> (X19:X30<>""))),COLUMN(X:X)))}
>
  Reply With Quote
Old 20-11-2003, 05:21 PM   #3
Phil Hageman
Guest
 
Posts: n/a
Default Thanks
Peo, Thanks very much - it works exactly as needed!
Appreciate your time. Phil
>-----Original Message-----
>One possible way
>
>=INDIRECT(ADDRESS(MAX(IF(ISNUMBER(ROW(19:30)*
(X19:X30<>"")),ROW(19:30)*(X19:
>X30<>""))),COLUMN(X:X)))
>
>array entered
>
>--
>
>Regards,
>
>Peo Sjoblom
>
>
>"Phil Hageman" <anonymous@discussions.microsoft.com>
wrote in message
>news:23a501c3af58$8585d7f0$a601280a@phx.gbl...
>> Is there a way to make this array formula ignore and
error
>> message in a cell in the range?
>>
>> {=INDIRECT(ADDRESS(MAX((ROW(19:30)*
>> (X19:X30<>""))),COLUMN(X:X)))}
>>
>
>
>.
>
  Reply With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off