Hide cell unless value entered into any cell on a row

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
 
S

Stefi

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

Regards,
Stefi

„Porky79†ezt írta:
 
S

Stefi

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

„Porky79†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide and Show Rows based on Cell Value 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
An Advance IF 3
hide row on spreadsheet 3
Rows to drop off (hide) when a value is entered into a cell 4
Creating a formula to highlight a row of cells 3
Expanding numbers and letters in a cell 4
Text treated as a numeric value? 4

Top