Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complicated Table
I have a database of customers, projects and category of projects. I
would like to create a table that would show every project by customer by category. For examples: Category I Category II ….. Customer 1 project a project f project b project g project c Customer 2 project d project h project e Can anybody think of a way of doing this either using one of Excel's existing functions (e.g., Pivot Table), VBA coding or a commercial add-in? I have tried fooling around with Pivot Table with little luck. However, I have been able to create a table for one Customer at the time using the Filter command, but I am hoping that there is simpler way to do this. Any help or advice would be much appreciated. Hman |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complicated Table
Pivot table might work with this if you had numerical information you were
trying to summarize or you wanted to get a count. Beyond that, there is no build in capability to do that. -- Regards, Tom Ogilvy "Hman" wrote in message om... I have a database of customers, projects and category of projects. I would like to create a table that would show every project by customer by category. For examples: Category I Category II ... Customer 1 project a project f project b project g project c Customer 2 project d project h project e Can anybody think of a way of doing this either using one of Excel's existing functions (e.g., Pivot Table), VBA coding or a commercial add-in? I have tried fooling around with Pivot Table with little luck. However, I have been able to create a table for one Customer at the time using the Filter command, but I am hoping that there is simpler way to do this. Any help or advice would be much appreciated. Hman |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complicated Table
Correct Tom, but Hman can simply use the pivot table as a binary matrix
to accomplish more or less the same result. I'm posting a sample to Hman, please check if it's what you need Regards, T.S. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated Look-Up | Excel Discussion (Misc queries) | |||
Complicated Table Functions | Excel Worksheet Functions | |||
rather complicated table to consolidate | Excel Discussion (Misc queries) | |||
complicated calculation in my pivot table | Excel Worksheet Functions | |||
How do you create a complicated pivot table graph? | Charts and Charting in Excel |