Hi all,
I'm currently working with a fairly large data set (a sample of which is attached) that contains a drop-down list of options that respondents can choose from.
I'm wondering whether there is a way to write a formula and preserve that formula when certain options are selected, but remove that formula from that column when others are present.
In other words, I would like to remove the formula when "Other" is selected (or if there is just an empty cell); when someone selects "Other", there should be nothing at all (not even the formula) in the cell, but NA should appear when the other options are selected.
Hopefully the attached workbook will clear the problem up slightly.
https://www.mediafire.com/file/cpixiu65q…tBook.xlsx/file
Any suggestions would be greatly appreciated, thank you!
Darko