Hide Zero Values and #N/A

[Unexpc]

Hi guys
i have two cell that i want be hidden when is empty
one cell is linked to a sheet that is formula
=Sheet!A1
and another cell show #N/A when function of this formula have not number in range =IF(MOD(ROW()-6,34)=0,"",IF(MOD(ROW()-7,34)=0,"",LOOKUP(2,1/(ISNUMBER(A:A)),A:A)))

 

[Tupe77]

Do you mean something like this?

=if(Sheet!A1="","",Sheet!A1)

=Iferror(IF(MOD(ROW()-6,34)=0,"",IF(MOD(ROW()-7,34)=0,"",LOOKUP(2,1/(ISNUMBER(A:A)),A:A))),"")

 

[jtakw]

Hi,

May be these?

=IF(Sheet!A1="","",Sheet!A1)

=IFERROR(IF(MOD(ROW()-6,34)=0,"",IF(MOD(ROW()-7,34)=0,"",LOOKUP(2,1/(ISNUMBER(A:A)),A:A))),"")

 

[Unexpc]

Do you mean something like this?

=if(Sheet!A1="","",Sheet!A1)

=Iferror(IF(MOD(ROW()-6,34)=0,"",IF(MOD(ROW()-7,34)=0,"",LOOKUP(2,1/(ISNUMBER(A:A)),A:A))),"")

Tupe77,jtakw Thank You, that is thing i want

 

[Tupe77]

Nice to know we were able to help.
Thanks!

 

[Phuoc]

A little shorter:

=IFERROR(IF(MOD(ROW()-6,34)<=1,"",LOOKUP(10^35,A:A)),"")

 

[Unexpc]

A little shorter:

=IFERROR(IF(MOD(ROW()-6,34)<=1,"",LOOKUP(10^35,A:A)),"")

Thank You Phuoc