Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoFilter and unique items
How to get a number of unique items in AutoFilter range?
-- regards/pozdrav! Berislav |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual AutoFilter - Vlookup, Index, Match, Array??? | Excel Worksheet Functions | |||
Best way to get a list of unique entries in a field | Excel Worksheet Functions | |||
AutoFilter lists unique values | Excel Discussion (Misc queries) | |||
Listing Unique Observations | Excel Worksheet Functions | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |