You can use an advanced filter to extract unqiue records.
See:
http://www.contextures.com/xladvfilter01.html#FilterUR
HTH
Jason
Atlanta, GA
-----Original Message-----
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
.