Finding groups in listing of many groups in XL 2010

In the attached XL 2010 worksheet, I have people listed and in column E I list all of the groups each person belongs to. I want to find just the people who are part of the * SG Non-Attorneys group. How can I find such people from a large spreadsheet when all the groups they are members of are all listed in the same field?
Filter_Find.xlsx
contrainAsked:
Who is Participating?
 
[ fanpages ]IT Services ConsultantCommented:
Would an output such as that included within the attached workbook be sufficient for your requirements?

If not, use of a Pivot Table may be a better solution.
Q_28980915.xlsx
0
 
Danny ChildIT ManagerCommented:
a fastndirty solution might be Conditional Formatting.. Highlight Cell Rules.. Text that Contains...
and define a colour to apply.

and then use a standard Filter to just show that colour.
0
 
contrainAuthor Commented:
I was able to combine both solutions. The first one enabled me to create columns of the text in the field as headings and from there I was able to just filter, as suggested in the second solution, on the headings and filter out the ones that did not contain the text I was looking for.
0
 
[ fanpages ]IT Services ConsultantCommented:
Erm, yes, that was my intention.  I didn't realise you needed guidance in, or a suggestion regarding how, to use MS-Excel's (Auto)Filter feature.

Glad we found a combined solution for you though.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.