Text Data Challenge - Looking for Options

Originally Posted by TMS

Add a header row; say, name, ID and group. Then insert a Pivot Table with name in the Row Labels and group as the Column Labels with a Count of the IDs.


Regards, TMS

	A	B	C	D	E	F	G	H	I	J
1	name	ID	group
2	joe	joe1234	groupB
3	joe	joe1234	groupC
4	leo	leo1234	groupA
5	leo	leo1234	groupC
6	joe	joe1234	groupA
7
8					Count of ID	Column Labels
9					Row Labels	groupA	groupB	groupC	Grand Total
10					joe	1	1	1	3
11					leo	1		1	2
12					Grand Total	2	1	2	5
13

I will need check that certain people are all members of certain groups, eg "make sure these 10 people are all members of these 3 groups...". I know I can use the list I'll get, likely by email, for an advanced filter on the pivot table source data, regenerate the pivot table, and then manually choose the groups to show from column label filter but is there a quicker way?