Previous Topic Next Topic

<< 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?

Related:

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 29, 2010 at 02:54 PM
Could you explain what you mean by list out available colors ?
0
Answer 2 / 2
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

Similar discussions

Comparing columns and returning value
ll -
kittu -

35 responses
Removing " false" value in "IF"
JIN -
share -

10 responses
Sorting Dates using Excel / VBA
kuldeps -
rizvisa1 -

5 responses
Help with array formula
Tbonekiller -
boboten -

1 response