Results 1 to 5 of 5

Delete duplicates based on two collumns

Threaded View

  1. #1
    Registered User
    Join Date
    06-19-2014
    Location
    Montreal
    MS-Off Ver
    Office 365
    Posts
    12

    Delete duplicates based on two collumns

    Hi,

    I have a big spreadsheet containing costumers purshases for a period. The same customer generally purshased the same product more than once. I need to eliminate all the duplicate lines based with the same value on 2 collumns, the customer (B) and the product (D) in order to keep only one line for each product that the customers purshased.

    Thanks for helping...

    Simon
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Delete Duplicates based on rule
    By hzarry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2016, 10:26 AM
  2. How to delete collumns range
    By Diamon in forum Excel General
    Replies: 4
    Last Post: 08-31-2015, 11:35 AM
  3. [SOLVED] Delete Duplicates based on Criteria
    By yuenk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2014, 11:56 AM
  4. Delete Duplicates based on Criteria
    By yuenk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2014, 11:48 AM
  5. [SOLVED] Delete duplicates based on criteria
    By chrism_cfu in forum Excel General
    Replies: 6
    Last Post: 12-07-2012, 08:52 AM
  6. [SOLVED] Delete duplicates based on DATES.
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-31-2012, 06:26 AM
  7. Delete duplicates based on cell value
    By uncleslinky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2011, 12:01 PM

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