Removing duplicate entries from a column
Posted by Dick Riker on February 07, 2002 7:01 AM
I frequently extract a long column of numbers from a report one of our office programs produces into an Excel spreadsheet. The column frequently and correctly includes quite a few duplicate (even triplicate) three to six digit numbers. For my Excel purposes, though, I need to eliminate all but one of these duplicates and/or triplicates along with all of the other data in that row. Any suggestions beyond tedious eye-balling?