Delete Every Second Duplicate Code
 

Hi All, Merry X-Mas!!!
I had a question: I have a spreadsheet that has up to three duplicate line
items: the same employee ID but different vacation dates, up to three
vacations for each employee. I will have the distributed into three tabs.
What is the best way to locate eery second line and every third line? Here is
what my plan is: have the same info on all three tabs. One the 1st one delete
every 2nd and 3rd dupl line item, on the second delete 1st and 3rd line and
on the 3rd delete 1st and 2nd lines. Please help me in finding a qyucker
solution. Thanks!!!