Hi,
I'm trying to figure out if it's possible to give one cell more than one value. In order to better describe what I mean I will give an example of it.
Car Model--Seats--Doors--Colors
R100--------2--------3-----Black; Red; Silver
R250--------4--------3-----Red; Blue; Grey
RS500-------4--------5-----Black; Blue; Gray
HC230-------4--------3-----Green; Red; Yellow
HC330-------5--------5-----Grey; Yellow; Brown
HC600i-------5-------5-----Brown; Silver; Blue
Suppose that I want to create a pivot chart of this. How should I type in the colors if I want to be able to choose any one color, i.e. red, and see what models comes in red, i.e. R100, R250 and HC230, and how many doors/seats the different "red" cars have.
Can anyone help me answer this?
Thak you, Sebastian)
Bookmarks