I have been trying to solve this problem but can’t seem to. I would be grateful if one of you awesome excel users would be able to help.
I have attached a sample sheet below.
What I’m trying to achieve is,
If Column F is Yes then sheet stays as it is. E.g. Column F/ Row 4
If Column F is No then Column G, H, I, J, K automatically come with the word N/A. E.g. Column F/ Row 5
All your help will be truly appreciated.