| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide cell unless value entered into any cell on a row
FANTASTIC!!
Thank you so much! Paul |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unlock cell dependent on value entered in another cell | Excel Discussion (Misc queries) | |||
| Change color of cell when different cell has data entered | Excel Discussion (Misc queries) | |||
| auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
| Hide cell values based on a condition in another cell | Excel Worksheet Functions | |||
| Rows to drop off (hide) when a value is entered into a cell | Excel Discussion (Misc queries) | |||
Linear Mode
