<< array>>

Closed
siokhuey - Mar 29, 2010 at 03:36 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Apr 3, 2010 at 08:48 AM
Dear all, I have a tough case on hand! tried to figure it for so long :( Hope some excel expertise can help me out :)

I have a table like this

Model Colour
Casio blue
Morgan yellow
Addidas red
Casio orange
Casio pink

I want to list out all the available colours under "casio" category. the list goes on. I hope the data validation box i do can automatically detect the information whenever i add in new data. how can i do this in excel?

2 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Mar 29, 2010 at 02:54 PM
Could you explain what you mean by list out available colors ?
0
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Apr 3, 2010 at 08:48 AM
do a google on excel pivot tables. think this is an ideal candidate for one
0