Consulting

Results 1 to 2 of 2

Thread: Compare 3 columns and delete the duplicates

  1. 08-13-2010, 03:53 AM #1
    ravic.yr
    ravic.yr is offline
    VBAX Newbie
    Joined
    Aug 2010
    Posts
    1
    Location

    Compare 3 columns and delete the duplicates

    I have to create the macro to compare the 2 columns and delete the
    duplicate rows ..

    can any one help me

    Thanks & Regards,
    Y Ravichandra
    Reply With Quote Reply With Quote
  2. 08-13-2010, 04:46 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    How will duplicates match up, will they be on the same row, or anything in one row that is in the other.? When a duplicate is found, delete from both columns, or just one.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules