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