EXCEL RADIO BUTTONS

[abduldrda]

Good Morning All.

I have made 3 RADIO BUTTONS in excel 1st one "YES", 2nd one "NO" and 3rd one "BOTH".
My data contains YES or NO in helper columns and I can extract YES data or NO data by clicking respective radio buttons.
How can i get YES & NO data by clicking "BOTH" but I dont have BOTH in the helper column.
Early reply is awaited.
Thank you all

 

[6StringJazzer]

I can extract YES data or NO data by clicking respective radio buttons

How are you doing this part?

 

[abduldrda]

How are you doing this part?

Sir, very sorry I forgot to attach EXCEL file. Can u plz tell me how to attach sample excel file?

 

[6StringJazzer]

This forum does not support attaching files to posts, only images. You can use a file sharing service like Dropbox, OneDrive, Google Docs, etc.

There is also an Excel add-in that lets you copy a range from your Excel file then paste it here and it looks like your worksheet, and the data and formulas can be seen and copied by others.

However, you can still explain what you are doing even without either of those.