Hi All!
I'm wanting to create a list of questions using excel that have radio button responses (Y, N, or N/A). I then want to be able to filter by the radio button responses - primarily, I want to filter so that I can see only the questions people responded 'Y' to. How the heck do I do that?
I'm using excel 2010; I tried just using form controls to insert radio buttons in a group box but I can't filter the columns doing that. Unfortunately, I know just enough about excel to realize I know nothing about it at all.
I'm wanting to create a list of questions using excel that have radio button responses (Y, N, or N/A). I then want to be able to filter by the radio button responses - primarily, I want to filter so that I can see only the questions people responded 'Y' to. How the heck do I do that?
I'm using excel 2010; I tried just using form controls to insert radio buttons in a group box but I can't filter the columns doing that. Unfortunately, I know just enough about excel to realize I know nothing about it at all.