Delete Every Second Duplicate Code

A

alish

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!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Help 1
import data from txt file to an existing excel file 1
Individual vacation calendars in a team resource 0
compare columns return first duplicate only 0
Compare columns pull unique values and first duplicate value 0
Tab sheet name 3
Delete duplicate rows of data when two columns are the same 6
populate time field based on field 8

Top