Hi Experts
I need a code that would hide a column if a particular cell in that column is empty.
Example:
If B6 is empty hide B column
If C6 is empty hide C column
If D6 is empty hide D column
Likewise if cell C6 is not empty then column B and C should not be hidden and if cell D6 is not empty then all 3 columns should not be hidden
Thank you
If I've helped U pls click on d *Add Reputation
Hello @bhenlee. Try.
Please Login or Register to view this content.
Thank you MikeVol.. the part where B6 is empty does not seem to work..
If B6 is empty then all 3 columns (B,C,D) should be hidden
Last edited by bhenlee; 06-23-2023 at 05:31 AM.
Where did you write about this in your original post? What you asked for and gave, decide for yourself. I think your question has been resolved. Good luck.Originally Posted by bhenlee
Last edited by AliGW; 06-23-2023 at 05:54 AM. Reason: Unkind & unhelpful remark removed.
@bhenlee, please list the columns you want hidden for each case (white letters = empty):
case 1 B C D case 2 B C D case 3 B C D case 4 B C D case 5 B C D case 6 B C D
My diagram is a table; you can copy it and paste in your reply, then just remove letters as needed.
Last edited by leelnich; 06-23-2023 at 06:00 AM.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
If B6:K6 are blank and L6 is not empty what are columns should be hidden. Is your condition For 3 columns B:D then E:G so on.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Hello @kvsrinivasamurthy.
And where do you see that they have such a range?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks