Thanks for your time and help tips. Yes ID,ID1,ID2 are key columns.With below sample data I want to compare data for ID,ID1,ID2 in each row ..Example for ID 1234 we have Satus DE,DE and EX rows..for this combination take max DE row and after that row find next EX row ..in this case this is the row which I want in my output file 1234 15115 EX 1444 4/10/10 11:06 AM 2/5/13 1:51 PM 4/11/2010 I want this row for this ID , ID1, ID2 I hope this is clear to some extent to give some idea on how we can do it.. Sample Data... ID ID1 Satus ID2 Date1 Date2 Date3 1234 15115 EX 1444 4/10/10 11:06 AM 2/5/13 1:51 PM 4/11/2010 I want this row for this ID , ID1, ID2 1234 15115 DE 1444 4/10/10 11:06 AM 2/5/13 1:30 PM 4/11/2010 1234 15115 DE 1444 4/10/10 11:06 AM 4/10/10 11:06 AM 4/11/2010 2345 16330 EX 1436 4/10/10 10:09 AM 2/5/13 2:15 PM 4/11/2010 I want this row for this ID , ID1, ID2 2345 16330 DE 1436 4/10/10 10:09 AM 2/5/13 2:04 PM 4/11/2010 2345 16330 DE 1436 4/10/10 10:09 AM 4/10/10 10:09 AM 4/11/2010 Thanks
... View more