Identify and replace row based on duplicate cell
I have an excel sheet that is being populated from a microsoft form. I have it sorting the data based on office location which is in column F. I need the sheet to automatically detect when two cells in column "G" are the same and replace the old row with the new one. Its drivin gme crazy!! haha. Thanks yall!
Sort your data so that the newer values are toward the top, then use Remove Duplicates on your table based on G. The older one (duplicated value lower on the sheet) will then have its entire row be removed.
Bernie Deitrick
Excel MVP 2000-2010
Hey Bernie, I like that way a lot, is there a way to have the excel sheet always looking for duplicates and sorting it based on G?
You may have an event macro fired when sheet is activated.excel sheet always looking for duplicates and sorting it based on G?
How do you "Sort your data so that the newer values are toward the top" ?
Send a short Excel sample for code test.
- Battle without fear gives no glory - Just try
Currently I am just using the auto sort feature, I haven't steered into the direction of macros yet, but an event macro every time its opened might be the easiest move.
Of course if its a shared file it might not like that.
So if there is a way for the sheet to auto sort and delete duplicates in shared folders that would be ideal. Even if i need to tie it to a button.
Can you send an EXCEL sample to prepare the job ?
Since you are using 365, you can combine UNIQUE and SORT and a bunch of other functions to create a clean data set continuously. A lot depends on how you add your new data - if you do it methodically, then lots of options....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks