AutoFilter and unique items
 

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

--
regards/pozdrav!
Berislav

AutoFilter and unique items
 

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=564029

AutoFilter and unique items
 

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

AutoFilter and unique items
 

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=564029

AutoFilter and unique items
 

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