Display material and activity

[Guest]

My list has several material that can be used for different activites. What
would be the best way to display the material with each unique activities?
For discussion purposes, in Sheet 1

Material Activity

Thinner Thinning
Thinner Equipment Cleaning
Primer Metal Coating
Primer Wood Coating
Thinner Thinning
Primer Metal Coating
Enamel Metal Coating
Enamel Wood Coating

Therefore in Sheet 2, a table with two columns will contain the following
information:

Material Activity

Thinner Thinning
Thinner Equipment Cleaning
Primer Metal Coating
Primer Wood Coating
Enamel Wood Coating
Enamel Metal Coating

 

[Jason Morin]

You can use an advanced filter to extract unqiue records.
See:

http://www.contextures.com/xladvfilter01.html#FilterUR

HTH
Jason
Atlanta, GA

 

[Guest]

Select the range and do data>filter>advanced filte, select copy to another
location and unique records only


Regards,

Peo Sjoblom

 

[Guest]

Thanks for your help. Would advanced filters update Sheet 2 if I add/update
information in Sheet 1.

 

[Frank Kabel]

Hi
no, advanced filter won't update automatically. You have to rerun the
filter.

Maybe a nice addin for this:
http://www.rondebruin.nl/easyfilter.htm