Complicated Table

H

Hman

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
 
T

Tom Ogilvy

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.
 
T

tantric surfer

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!
 
Top