Hey there
I am wondering if anyone can help me with an issue. I have data that I need to remove duplicates from (large amount of data) so i have been pasting it as text to excel from access and then removing the duplicates using specific criteria. However a fellow collegue has been doing the same but not pasting as text and they are getting different results. Does anyone know which way it should be pasted? We are using the same criteria to remove the duplicates. Any help would be greatly appreciated.
I am only guessing that it is the way the data is pasted that is causing the different results. If anyone has any other ideas as to what could be causing the different results that would help me out too.
Thanks
Last edited by joebju; 11-11-2008 at 04:06 PM. Reason: ASAP!!!!
Anyone have any ideas?
Or can direct me to somewhere else I can look?
Last edited by joebju; 11-11-2008 at 04:06 PM. Reason: need help ASAP!!!
Could you give a example of your Data?
I wrote a thing... might help... lemme find it....
Ah ha!
Might be able to use that in order to find why some are counted as duplicates by you and not by him, or vice versa.
Just tells you how many duplicates there are though, doesn't tell you WHERE they are.
I suppose a guy could make it do that too with some effort...
I am using data from access that is copied to excel (not exported) and pasted (either just paste, or paste as text) then I am using the remove duplicates feature in Excel 2007 to check for the dups.
I will try to get an example together and post it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks