AutoFilter and unique items

[b&s]

How to get a number of unique items in AutoFilter range?

--
regards/pozdrav!
Berislav

[VBA Noob]

Instead of Filter use Advance filter. Select range and tick Unique items.

Select visible and copy to any location then click cell you want to copy to.

Attached some links on Advance Filters

http://www.dailydoseofexcel.com/arch...vanced-filter/

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

VBA Noob

[b&s]

Thanks for trying to help me, but there is another reason we have to use
AutoFilter.

--
Berislav


VBA Noob wrote:
> Instead of Filter use Advance filter. Select range and tick Unique
> items.
>
> Select visible and copy to any location then click cell you want to
> copy to.
>
> Attached some links on Advance Filters
>
>
http://www.dailydoseofexcel.com/arch...ues-advanced-f
ilter/
>
> http://www.contextures.com/xladvfilter01.html
>
> VBA Noob

[VBA Noob]

Hi again


This link might help

If you entry another col with this forumla in it. Change Range1 to Range or name range Range1. Then filter then filter again on Duplicates

http://www.cpearson.com/excel/duplicat.htm

VBA noob

[b&s]

VBA Noob wrote:
> Hi again
>
>
> This link might help
>
> If you entry another col with this forumla in it. Change Range1 to
> Range or name range Range1. Then filter then filter again on
> Duplicates
>
> http://www.cpearson.com/excel/duplicat.htm
>
> VBA noob

Thanks for your time!


--
regards/pozdrav!
Berislav