Text Data Challenge - Looking for Options

This version of the file that I uploaded is edited to allow 2000 rows of data with Data Validation to prevent duplicate entries of the name and group combination.

On the Summary worksheet, the Filter has been activated. This allows you to filter by group or groups....select 1 if you want that group included. In the name column, select the names that you are interested in. You can combine names and groups to form a filter of the records.