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

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





.

Select the range and do datafilteradvanced filte, select copy to another
location and unique records only


Regards,

Peo Sjoblom

"lintan" wrote:

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

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

"Peo Sjoblom" wrote:

Select the range and do datafilteradvanced filte, select copy to another
location and unique records only


Regards,

Peo Sjoblom

"lintan" wrote:

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

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

--
Regards
Frank Kabel
Frankfurt, Germany
"lintan" schrieb im Newsbeitrag
...
Thanks for your help. Would advanced filters update Sheet 2 if I
add/update
information in Sheet 1.

"Peo Sjoblom" wrote:

Select the range and do datafilteradvanced filte, select copy to
another
location and unique records only


Regards,

Peo Sjoblom

"lintan" wrote:

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