Hi,
Here is my issue. I have a spreadsheet like the example below. What I want is to get rid of the duplicate ssn line that has the oldest date in the "process" column. So for this example I want to get rid of the entire line 2nd line. I can come up with some longer ways of doing this but it seems as if there should be a quick way. Thanks!
Number ------ Date ---------- Process
123456 --- 02/05/2006 --- 06/05/2008
555555 --- 01/01/2007 --- 06/01/2008
555555 --- 05/27/2008 --- 06/08/2008
Bookmarks