Ignoring error msg

[Phil Hageman]

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)))}

 

[Peo Sjoblom]

One possible way

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

array entered

 

[Phil Hageman]

Peo, Thanks very much - it works exactly as needed!
Appreciate your time. Phil