Forum Discussion
Isolating and Aggregating Data
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!!
3 Replies
- If this is a one-off you could filter your table on that column and then copy the filtered content to another area of the spreadsheet.
- Thanks! Unfortunately I don’t think asked the question clearly. As an example, after the user answers either yes or no to an item, I want have the yeses and the corresponding items that were answered yes moved into a separate worksheet within the spreadsheet. Sorry for the second question but I am not sure what I am looking for can be achieved. Thanks again for your help!
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.
