contrain
asked on
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
Filter_Find.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Glad we found a combined solution for you though.
ASKER