Hide cell unless value entered into any cell on a row
 

Hi guys -

I have a worksheet that contains a summary of data that is entered in
a different part of the same worksheet (i.e. Page 1 in the worksheet
is the printable report).

I want to hide a title in the summary section (lets say this is cell
A1) unless data is filled into any cell in a specified row
(J14:T14).

Using the IF principle I thought I could use =IF(J14:T14,I14,"") -
where J14:T14 is the row where data is entered and I14 is the text
that I want displayed in A1 should there be data entered in this row.

comes up with #VALUE!

Any ideas where I am going wrong or if this is actually possible?

Thanks

Hide cell unless value entered into any cell on a row
 

=IF(NOT(ISBLANK(J14:T14)),I14,"")
It's an array formula, confirm it with Ctrl+Shift+Enter!

Regards,
Stefi

€žPorky79€� ezt Ã*rta:

Hi guys -

I have a worksheet that contains a summary of data that is entered in
a different part of the same worksheet (i.e. Page 1 in the worksheet
is the printable report).

I want to hide a title in the summary section (lets say this is cell
A1) unless data is filled into any cell in a specified row
(J14:T14).

Using the IF principle I thought I could use =IF(J14:T14,I14,"") -
where J14:T14 is the row where data is entered and I14 is the text
that I want displayed in A1 should there be data entered in this row.

comes up with #VALUE!

Any ideas where I am going wrong or if this is actually possible?

Thanks

Hide cell unless value entered into any cell on a row
 

FANTASTIC!!

Thank you so much!

Paul

Hide cell unless value entered into any cell on a row
 

You are welcome! Thanks for the feedback!
Clicking the YES button will be appreciated.
Stefi

€žPorky79€� ezt Ã*rta:

FANTASTIC!!

Thank you so much!

Paul