Delete matching cells
On Mon, 16 Jan 2012 07:49:46 -0800, "Jim Cone" wrote:
Garry,
It may turn out to be one of those days, especially if the snow sticks.
I plugged in a new set of sample data into xl2010 this morning.
It appears that your code is returning mismatched items... items in col A that are not in Col B.
But it is not eliminating duplicates.
Column A has 360,000 random 6 digit numbers.
Column B has 240,000 random 6 digit numbers.
Ron's code returns 231,414 unique entries.
Your code returns 279,200 entries: 231,514 unique and 47,686 duplicates.
(i ran my own unique counter on your returned data)
It's too early in the day for me to try to figure out why. <g
'---
Regards,
Jim Cone
Jim,
I believe I mentioned that in response to Gary's posting a version where he did not use the dictionary for column A. He actually WAS looking for a way to PRESERVE the duplicates in Column A, and I opined that that particular version should do so.
The "why" is because by not using a dictionary to collect the non-matches for column A, the duplicates do not get filtered.
So, if preserving duplicate entries in Column A is a requirement, Gary's version will do so.
-- Ron
|