Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Compare columns for duplicates

I want to compare names of one column to names of another column to find the
non duplicates. How can i do this?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 345
Default Compare columns for duplicates

Try looking at:
http://support.microsoft.com/kb/213367


"acab" wrote:

I want to compare names of one column to names of another column to find the
non duplicates. How can i do this?

Thanks

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 345
Default Compare columns for duplicates

I forgot to point out that after you have applied the Microsoft formula
solution apply a Blank filter to column B and there is your list of non
duplicates

"acab" wrote:

I want to compare names of one column to names of another column to find the
non duplicates. How can i do this?

Thanks

Reply
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
Compare 2 columns and align duplicates into same row AGOLFA Excel Worksheet Functions 8 November 9th 09 07:48 PM
Compare columns remove duplicates Tommy Geek Excel Discussion (Misc queries) 1 December 21st 06 06:42 PM
How to compare two columns and remove duplicates? username123 Excel Discussion (Misc queries) 15 July 5th 06 04:06 PM
Compare the 1st 9 digits in two columns looking for duplicates Sweetetc Excel Worksheet Functions 9 March 26th 06 11:58 PM
compare two columns and remove duplicates Moni39 Excel Worksheet Functions 3 May 5th 05 06:08 PM


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