+ Reply to Thread
Results 1 to 2 of 2

Delete a row based on multiple column repeated data

  1. #1
    Registered User
    Join Date
    05-13-2005
    Location
    Glorious Sunny North West England...
    Posts
    2

    Delete a row based on multiple column repeated data

    Well Hello Ladies and Gentlemen.

    I have been lurking around this site for a while and have found the answers to most of my problems, so thanks to you all.

    However I now have a hum-dinger of a problem that I can't solve.

    Purely for example consider this:

    a b c
    1 Smith Mon 2 apples
    2 Jones Mon 3 apples
    3 Smith Tue 2 apples
    4 Smith Tue 2 apples
    5 Jones Wed 3 apples
    6 Jones Wed 5 apples

    What I want to do is delete duplicates in this list (row 3&4, delete row 4) but leave non-similar rows alone (row 5&6 where Jones buys more apples on the same day).

    Most of the deletion codes I have seen will delete a row based on the data in a single column. However I need to check for repeated data in three columns and only delete when all three columns contain the same data.

    The code I have, from http://www.cpearson.com/excel/deleting.htm will delete the row based on a single column value and it's beyond my tiny mind to get it to check the criteria of all three columns.

    HELP.....

  2. #2
    Registered User
    Join Date
    05-13-2005
    Location
    Glorious Sunny North West England...
    Posts
    2
    Come on Guys!!

    A little help would be appreciated.
    -----------------------------------------------------------

    Judging by his outlandish attire
    He's some kind of free thinking radical

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1