+ Reply to Thread
Results 1 to 2 of 2

How To Automatically Remove Duplicates rows by date In Excel

  1. #1
    Registered User
    Join Date
    01-13-2019
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    9

    How To Automatically Remove Duplicates rows by date In Excel

    Hello,

    I would like to know how I would automatically create a formula(s) to remove duplicate rows of data based on columns Completion Time, Today's Date,and Store Name. I want to also keep the lastest entry of the duplicate based on Completion Time.

    In the image, I provided you can see that rows 10-11, 12-13, and 14-16 have duplicate entries for the day. I only want to keep the latest one that was entered based on Completion Time.

    Thank you!
    Attached Images Attached Images

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,198

    Re: How To Automatically Remove Duplicates rows by date In Excel

    A picture is of little practical use to us.

    There are instructions at the top of the page explaining how to attach your sample workbook.

    You cannot REMOVE entries with a formula. You can filter out the data you want to keep to a NEW table using a formula or PowerQuery, but the original data would need to stay intact. If what you want really is to REMOVE, then you will need VBA. Let us know, please.
    Last edited by AliGW; 10-04-2021 at 03:02 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sum up rows then remove duplicates
    By hsduk101 in forum Excel General
    Replies: 1
    Last Post: 03-04-2021, 07:47 AM
  2. How to remove rows that are NOT duplicates
    By ecruz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-23-2015, 04:51 PM
  3. [SOLVED] Find duplicates rows, sum cells then remove duplcate rows
    By Wagstaff in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-22-2013, 09:37 AM
  4. Remove rows without Duplicates
    By Apple1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2013, 10:12 AM
  5. Replies: 1
    Last Post: 10-23-2012, 09:12 AM
  6. [SOLVED] How to remove duplicate rows only if columns A and B are BOTH duplicates in Excel 2003
    By Benisato in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-22-2012, 03:53 AM
  7. [SOLVED] How do I remove repeating rows automatically in excel?
    By frankie@stamford.edu.my in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2005, 10:20 PM

Tags for this Thread

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