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

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

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!