I know how to create drop-down lists, and how to create data validation drop-down lists where you can choose multiple answers. My issue is, I can't figure out how to create said lists where, if you accidentally choose a second answer, or the wrong second answer, it's possible to erase that second answer. Right now when I select a second (or third, or fourth, etc.) answer, I'm not able to delete it to go back to just having the single answer.
So...
if the drop-down list options are "a, b, c, and d," and I first choose "a," I currently have it set up so that I can then click back on the list, and choose another option so that I now have "a, b" in the cell (or a, d or a, c, etc). I can't delete "b" then, though, so I'm stuck with "a, b" in that cell.
If I'm going to sell this to my coworkers as something they can use as a data tracking tool, it's got to be very user-friendly. Is there any way to get this to happen in a way that wouldn't require multiple steps and would just be as simple as deleting that second answer?
Thanks much to anyone who can help assist this ignorant unpaid intern!