Hide cell unless value entered into any cell on a row

  • Thread starter Thread starter Porky79
  • Start date Start date
P

Porky79

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
 
=IF(NOT(ISBLANK(J14:T14)),I14,"")
It's an array formula, confirm it with Ctrl+Shift+Enter!

Regards,
Stefi

„Porky79†ezt írta:
 
You are welcome! Thanks for the feedback!
Clicking the YES button will be appreciated.
Stefi

„Porky79†ezt írta:
 
Back
Top