Feb 07 2019 06:37 AM
I need help trying to isolate user-selected data (Yes or No) within a data set in a worksheet.
Once the user makes the appropriate selection, the spreadsheet would the aggregate all of the “Yeses” from the worksheet into a new worksheet contained within the spreadsheet.
I believe there must be an easy way to do this but it beyond my level of proficiency. Thank you in advance!!
Feb 07 2019 06:59 AM
Feb 07 2019 05:24 PM
Feb 07 2019 10:13 PM
Select Data, From Table. Now filter the column with Yes/No for the Yes'es and press close&Load and then point to the locaton where you want the result. After more yes/No answers have been collected you simply click Data, Refresh All.