LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 108
Default Filter for unique values in multiple columns

I have a data list on 10 columns. I'd like to fitler and remove the the
duplicates based on col A only. Advance filter will filter single col. How
can I keep unique codes on col A and remove all the duplicates codes in colA
along with the rest of the records on the other 9 colunms?

Thanks.
--
when u change the way u look @ things, the things u look at change.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
List Unique Values from multiple columns Chance224 Excel Discussion (Misc queries) 0 June 19th 08 08:06 PM
List unique Values from different columns: How to... dakke Excel Discussion (Misc queries) 6 February 14th 08 11:34 PM
Filter for Unique Values not working Joe M. Excel Discussion (Misc queries) 1 February 4th 08 03:11 PM
count unique values & filter paula k Excel Worksheet Functions 2 January 23rd 07 05:18 PM
How do I get unique values from 2 columns? akmccarthy Excel Discussion (Misc queries) 2 December 13th 04 10:47 PM


All times are GMT +1. The time now is 09:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"