|
Display material and activity
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 |
| All times are GMT +1. The time now is 07:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com