Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter unique values Excel
Hi, I want to automatically filter out all non unique data from my Excel column's. How do I do this? I already tried the data-filter function. Thanks Michieol -- vrijbergen ------------------------------------------------------------------------ vrijbergen's Profile: http://www.excelforum.com/member.php...o&userid=27757 View this thread: http://www.excelforum.com/showthread...hreadid=472677 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter unique values Excel
Data=filter=Advanced filter and click the unique checkbox. This will show
you a list of uniques. -- Regards, Tom Ogilvy "vrijbergen" wrote in message ... Hi, I want to automatically filter out all non unique data from my Excel column's. How do I do this? I already tried the data-filter function. Thanks Michieol -- vrijbergen ------------------------------------------------------------------------ vrijbergen's Profile: http://www.excelforum.com/member.php...o&userid=27757 View this thread: http://www.excelforum.com/showthread...hreadid=472677 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter unique values Excel
vrijbergen:
Try searching for 'Find Duplicates' in the Excel online help. Here's what they suggest: Filter for unique records Select the column or click a cell in the range or list you want to filter. On the Data menu, point to Filter, and then click Advanced Filter. Do one of the following. To filter the range or list in place, similar to using AutoFilter, click Filter the list, in-place. To copy the results of the filter to another location, click Copy to another location. Then, in the Copy To box, enter a cell reference. To select a cell, click Collapse Dialog to temporarily hide the dialog box. Select the cell on the worksheet, and then press Expand Dialog . Select the Unique records only check box. Note Once you filter for unique values, you can copy them to another worksheet and then archive or delete the original worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count unique values with auto-filter on | Excel Worksheet Functions | |||
Filter Unique Values | Excel Worksheet Functions | |||
Filter for Unique Values not working | Excel Discussion (Misc queries) | |||
count unique values & filter | Excel Worksheet Functions | |||
Advanced Filter - Unique Values | Excel Programming |