Forum Discussion
Survey Ranking Validation
mathetesGood Morning & Thank You - We were unable to get this to work on our end. We are using Office 2010, not sure if that makes a difference. Or perhaps we were suppose to make some modifications on our end to test this for D4. Nonetheless thank you very much - you are so kind to spend your time on this. Blessing to you.
DataGeek2020 You probably don't have those new functions (neither do I). Try this:
Similar to mathetes sheet create a filtered column and use this formula:
=IFERROR(IF(MATCH(G3,$E$3:$E$7,0)>0,"",G3),G3)
where the drop-down input is in $E$3:$E$7 and the full list of options is in G3:G7 and this formula is in column H (this specific formula is in H3 and you fill down to H7)
the data validation is a list based on column H
so basically as they select a value in the drop down in column E then column H hides that value.