I have a sheet that has an identifier like 1325686468.2958 on each line of column H. The digits leading up to the "." are the one's that matter to me. I need to keep 1 entry for each unique identifier. I have a macro that I picked up that deletes the entire row based on duplicates in the selected column which is great but I need it modified to first eliminate the 4 trailing digits. Also, this identifier will always be in column H, can i make it run there everytime instead of having to select that column first? Any help would be greatly appciated.
Bookmarks