Jimmy
Resident Freddy
- Joined
- Aug 24, 2006
- Messages
- 1,072
Evening Folks
I need some advice on excel 2003. I'm currently helping a team at work find and delete duplicates from there sheets they use, find them isn't the issue but getting rid of them in bulk is.
What we have is a workbook with about 7-8 tabs each with account numbers on, over all there is 26k accounts on the workbook, what happens is when the team needs to work an account they copy the number from the row and paste it to the bottom while leaving the the old one at the top (Retarded i know) and continue this for each account they work creating the duplicates. All i have is that the duplicates i need to delete are at the top there is also no date to say when each one was worked ant idea's on how to delete them on mas rather than go trough each one?
any help is much appricated.
Ps sorry for any shit grammer
I need some advice on excel 2003. I'm currently helping a team at work find and delete duplicates from there sheets they use, find them isn't the issue but getting rid of them in bulk is.
What we have is a workbook with about 7-8 tabs each with account numbers on, over all there is 26k accounts on the workbook, what happens is when the team needs to work an account they copy the number from the row and paste it to the bottom while leaving the the old one at the top (Retarded i know) and continue this for each account they work creating the duplicates. All i have is that the duplicates i need to delete are at the top there is also no date to say when each one was worked ant idea's on how to delete them on mas rather than go trough each one?
any help is much appricated.
Ps sorry for any shit grammer