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
Bookmarks