Hi,
I have a large file of 55,000 rows and in Column D i have duplicate records which i want to separate it from the unique records.
I need a create 2 sheets one of uniques & duplicates records.
This task can be completed with the help of macro because of large data file & which is regular,
Thanks in advance.
What is a unique and what is a duplicate in your context?
Say you have a list
X
X
X
Y
Is Y the only unique in this list by your criteria and X (how many of them ?) the only duplicate(s)?
Do your duplicates/uniques, however defined, refer to rows, complete cells, parts of cells, formats, ... ???
Hi fareen,
Try this:
Regards,
Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Try this,
Please Login or Register to view this content.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks