eurotransient Wrote:
Hello,
I've got two massive columns of numerical data, A and B. I need to
compare the content of the two columns and come up with a column "C",
which consists of all numbers that appear ONLY in column B.
Please help...this will eliminate a full day of tedious work if I can
get this done with a formula.
Thank you in advance for your guidance.
Robert
Enter this formula in C1 (adjusting the range to suit your needs)
=IF(COUNTIF($A$1:$A$100,B1)=0,B1,\"\")
and copy down until your range requirements are met.
Regards.
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=473024