Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Comparing 2 Columns for duplicate data

Hello,

Can someone please help me. Im looking for a Macro that will sca
through columns A - B for matching entries and delete those it finds i
column A.

___A___B__
1.| N | H |
2.| B | I |
3.| C | J |
4.| D | K |
5.| E | L |
6.| F | M |
7.| G | N |<--- N found deleting duplicate in cell A1

Thanks

--
Message posted from http://www.ExcelForum.com

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
Comparing two columns of data Wayne Excel Worksheet Functions 2 January 12th 09 04:31 PM
Comparing data in two columns Norm Excel Worksheet Functions 1 June 10th 08 03:10 PM
Comparing columns of data Hankjam Excel Discussion (Misc queries) 2 April 23rd 07 09:26 PM
comparing lists of data to remove duplicate data Tom Excel Discussion (Misc queries) 2 October 13th 05 06:16 PM
Comparing 2 rows for duplicate data bkbri[_7_] Excel Programming 4 April 20th 04 08:39 AM


All times are GMT +1. The time now is 05:01 PM.

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

About Us

"It's about Microsoft Excel"