slang
03-06-2015, 08:41 AM
I have a datasheet that has somehow had duplicates introduced into it. there is no time / date stamp to indicate which one is the newest but from the data the newest one always appears first in the list from top to bottom.
I was thinking about a simple script that would start at the bottom of the list and check if there were dups above it and if so delete the row them offset to the next row and do it all over again until the top of the list.
Question, how do I answer the question is there a duplicate in the list above to throw the switch to delete as the reference to the list will change as rows are deleted.
data is in column A
Haven't been coding for a while so am a bit rusty:help
Using Excel 2010
I was thinking about a simple script that would start at the bottom of the list and check if there were dups above it and if so delete the row them offset to the next row and do it all over again until the top of the list.
Question, how do I answer the question is there a duplicate in the list above to throw the switch to delete as the reference to the list will change as rows are deleted.
data is in column A
Haven't been coding for a while so am a bit rusty:help
Using Excel 2010