View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bkbri[_8_] bkbri[_8_] is offline
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