
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel Analysis Toolpak
Excel Customer Service

May 21, 2021

Hello, I have a data table that needs to be updated daily with new entries containing duplicate IDs within the ID column. I am looking for a solution to remove the previous rows that match the new entry based on the ID number while keeping the latest entry intact. I have tried to come up with a solution but need help. Could you please provide me with the necessary Mcode or guidance to help me create this process? Thank you.


Trusted Members
Moderators

January 31, 2022


Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel Analysis Toolpak
Excel Customer Service

May 21, 2021



Trusted Members

October 18, 2018


Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel Analysis Toolpak
Excel Customer Service

May 21, 2021

As new data is added, it is appended. I am a newbie here. My thought was to add an index column as one of the first steps. I don't know, really. Maybe I need to add a date column to the raw data before loading it to power query?
The CDOM (Cumulative Days on Market) column may be the best resource for identifying the latest entry unless there were multiple changes to an MLSNumber on the same day. I really don't know what the best practice is.
Your guidance is appreciated!
1 Guest(s)
