LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jill
 
Posts: n/a
Default Have 2 columns of names - need to filter out names not duplicated

Hi I have two columns of names - Column A 1,377 names, Column G 1,456 names.
Most are duplicates. I want to see the names in another column that are not
duplicates. How do I use VLOOKUP to do this? Or do you have any other
suggestions?
 
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
Macro for Filter Switches ... Maybe??? Ken Excel Discussion (Misc queries) 4 February 25th 05 05:30 PM
Finding Duplicated Text within Columns Jen Excel Discussion (Misc queries) 1 February 15th 05 02:43 PM
Filter two columns with criterion applying to one or the other? Peter Frank Excel Discussion (Misc queries) 1 January 26th 05 03:54 PM
How do I change the names of the cells or columns from "A" to wha. Jeanne New Users to Excel 1 January 7th 05 03:10 AM
How can I find the common names in two columns of names? hako Excel Discussion (Misc queries) 2 December 8th 04 01:59 AM


All times are GMT +1. The time now is 01:17 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"