How to get a number of unique items in AutoFilter range?
--
regards/pozdrav!
Berislav
How to get a number of unique items in AutoFilter range?
--
regards/pozdrav!
Berislav
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
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
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 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks