Hello everyone, I am trying to get rid of some duplicate records based on: 1. If A, C, D, E, F, G is same AND 2. The difference between B is lower than 42 days A B C D E F G SL00106714 2013-08-26 TOE R S S S SL00106714 2013-11-12 TOE R S S S SL00106723 2013-04-17 NARE SL00106723 2013-04-17 NARE SL00106739 2013-04-14 THIGH R S S S SL00106781 2010-05-04 SKIN S S S SL00106781 2010-05-04 TOE S S S SL00106781 2012-11-25 CHIN R R S S SL00106781 2013-01-07 BLOOD R R S SL00106781 2013-01-07 BLOOD R R S SL00106781 2013-02-01 BLOOD R R S S SL00106781 2013-05-22 ELBOW R R S S SL00106781 2013-07-26 ELBOW R R S S For example, for records between row 7 and 14, I would want to eliminate row 11 Is there a way to do this? Thank you very much in advance!
... View more