How do I hide data in column until data is entered in columns to the left?
Requirement:
I want to hide data in cell "F" until data in cells "D" and "E" is entered.
Solution:
=if(or(E1="",D1=""),"",C1/D1) then copy down
Obtained from the OzGrid Help Forum.
Solution provided by Alan Sidman. There is a growing focus on individual facets of health and fitness. What health and fitness are very much key innovations in and of themselves, they also come hand in hand with many moving pieces within these two fundamental constructs that all have their own purpose and their own role to play. The future of the health and fitness ndustries is very much reliant on how big the rising pools of interest in investment continue to spiral out and create valuable impact well into the future and beyond.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to Delete/Hide every nth row |
| How to hide and unhide with checkboxes - multiple checkboxes do multiple different things |
| How to use Excel VBA code to hide based on criteria |
| How to reference text in cell to unhide worksheet |
| How to unhide worksheets identified by specific cells in main sheet |
| How to hide rows based on 2 value |
| How to hide columns in sheet 2 based on data change in sheet 1 |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
