Autofilter

[ester]

Hi, not sure if I'm posting in the right place... anyhow,
I've a simple list of products from different companies, using autofilter, I'm able to extract the companies who sells the same product.

Is it possible to to extract the criteria range from autofilter (without using print screen :wink: )?

 

[tactps]

Sure - Use advanced filter, as follows:

Highlight the column you want.

From the "Data" nemu choose advanced filter.
Click on "copy to another location"
Type the reference for the list in the "copy to" box
Click on "unique records only"
Click on ok.

 

[ester]

thanks