tcmmaxt
asked on
how do you separate and print/list a certain group in an Microsoft Office Excel Worksheet
Expert:
New to Microsoft Office Excel Worksheet. I have an Excel Worksheet with a list of people's names in one column called "Names" and another column called "Group" which shows the respective group that the person belongs too. I need someone to show me how to break out and print/list the Names by Group. any help how to do this would be great
Example
Group Names
blue mary doe
blue joe doe
abc tom smith
xyz john doe
xyz jim brownt
HYT larry doe
HYT betty kingy
New to Microsoft Office Excel Worksheet. I have an Excel Worksheet with a list of people's names in one column called "Names" and another column called "Group" which shows the respective group that the person belongs too. I need someone to show me how to break out and print/list the Names by Group. any help how to do this would be great
Example
Group Names
blue mary doe
blue joe doe
abc tom smith
xyz john doe
xyz jim brownt
HYT larry doe
HYT betty kingy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
nutsch:
I have lots of columns. Column A is the "Names" column and column E is the "Group" column
A "Create PivotTable popup" appeared with
Table/Range: 'Report_(All_people)(1)'!$ A$1:$G$100 0
and with default checkbox = New Worksheet
now please to tell me what do I have to do to "Put the Group and Names as column Fields" as you indicated?
I have lots of columns. Column A is the "Names" column and column E is the "Group" column
A "Create PivotTable popup" appeared with
Table/Range: 'Report_(All_people)(1)'!$
and with default checkbox = New Worksheet
now please to tell me what do I have to do to "Put the Group and Names as column Fields" as you indicated?
Which excel version are you on?
T
T
ASKER
again thanks:
the file has a .xlsx extension excel 2007
the file has a .xlsx extension excel 2007
T