displaying unmatched data

**blizzstorm** · 03-10-2009, 05:11 PM

Hi all,

Need your kind help in this problem, not sure where to start.

to describe my issue in a simple way: I have two columns with tons of identical data and i need to match each datacell in column A with an identical datacell in column b.

The thing is there are many identical data such as "1000" each "1000" needs to match with another "1000" in column B and i need to display whats left unmatched eg. 5 "1000" in column A and 6 "1000" in column B should show a leftover of 1 "1000" for column B and vice versa.

Hope you guys can point me a direction where i can follow.

Another example:

Column A
--------
1000
1000
1000
999
999
444
444

Column B
---------
444
999
444
1000
1000
1000
1000

So display should be showing unmatched "Column A: 999" & "column B:1000"

Doing this i would like to preserve the raw data as well

Appreciate it alot!

http://www.mrexcel.com/forum/forumdisplay.php?f=10 Crossposted

**GuruWannaB** · 03-10-2009, 05:13 PM

Can you upload an example file?

**VBA Noob** · 03-10-2009, 05:14 PM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!