Columns SUBSTRACTION or something
I have this worksheet having 2 columns of numbers. I need help from you for getting this 3rd column meeting the following condition:
- all numbers in column B that are NOT in column A
Maybe it is easy, but I don't have a clue how can be done.
if you are prepared to do a few steps which wont take long
in C1 put =IF(ISNUMBER(MATCH(B1,A:A,0)),"",B1)
and copy this down column c to the end of column B where you numbers run out
Select column B copy paste special and past as values on top of itsself to loose the formulas
Now just sort column C to loose the blanks
thank you thank you thank you thank you thank you thank you thank you
What a great forum!! Quick answer, documented and effective answers.
Forum and Excel rule.
Did I say thank you? :D
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1