Complicated Table

  • Thread starter Thread starter Hman
  • Start date Start date
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
 
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.
 
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.
 
Back
Top