Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color Code Duplicate items. | Excel Discussion (Misc queries) | |||
VBA Code macro for duplicate entries | Excel Discussion (Misc queries) | |||
How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
Duplicate a code | Excel Discussion (Misc queries) | |||
Delete Duplicate | Excel Discussion (Misc queries) |