Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to arrange several tasks that are assigned to a few names on a
SS. I thought a Pivot Table would be great for this, since PTs handle duplicates so nicely. I have used PTs many times in the past, but I cant remember ever using text in a PT. Can this be done or not? Let's say Sam Smith is responsible for the following: Life operations Foreign General operations Consumer Finance operations I wanted to see something like this: Sam Smith Life operations Foreign General operations Consumer Finance operations Etc........ Can anyone recommend a viable alternative? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
RyGuy, Pivot Tables work great with text. It is all about the format of the
Data Table that the Pivot Table is based on. The spreadsheet should look something like this: ColA ColB Sam Smith LifeOperations Sam Smith Foreign General operations John Smith Finance Then add colB to the pivot table as the data and Col A as the Row Field. -- Charles Chickering "A good example is twice the value of good advice." "RyGuy" wrote: I am trying to arrange several tasks that are assigned to a few names on a SS. I thought a Pivot Table would be great for this, since PTs handle duplicates so nicely. I have used PTs many times in the past, but I cant remember ever using text in a PT. Can this be done or not? Let's say Sam Smith is responsible for the following: Life operations Foreign General operations Consumer Finance operations I wanted to see something like this: Sam Smith Life operations Foreign General operations Consumer Finance operations Etc........ Can anyone recommend a viable alternative? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
After many futile attempts, I just double-clicked on the items in Col B and
it worked. Thanks for letting me know it was possible Charles! I'm off to celebrate New Years Eve with some friends. Happy New Year!! Ryan--- -- RyGuy "Charles Chickering" wrote: RyGuy, Pivot Tables work great with text. It is all about the format of the Data Table that the Pivot Table is based on. The spreadsheet should look something like this: ColA ColB Sam Smith LifeOperations Sam Smith Foreign General operations John Smith Finance Then add colB to the pivot table as the data and Col A as the Row Field. -- Charles Chickering "A good example is twice the value of good advice." "RyGuy" wrote: I am trying to arrange several tasks that are assigned to a few names on a SS. I thought a Pivot Table would be great for this, since PTs handle duplicates so nicely. I have used PTs many times in the past, but I cant remember ever using text in a PT. Can this be done or not? Let's say Sam Smith is responsible for the following: Life operations Foreign General operations Consumer Finance operations I wanted to see something like this: Sam Smith Life operations Foreign General operations Consumer Finance operations Etc........ Can anyone recommend a viable alternative? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying related information between worksheets | Excel Discussion (Misc queries) | |||
Extracting Information from A Pivot Table | Excel Discussion (Misc queries) | |||
How does one sort a block of inter-related information in Excel? | Excel Worksheet Functions | |||
How to get information from a Pivot TAble without retyping? | Excel Discussion (Misc queries) | |||
SUMIF other related field contains certain information | Excel Discussion (Misc queries) |