Excel Help - HotUKDeals
Get the HotUKDeals app free at Google Play

#### Search Error

An error occurred when searching, please try again!

# Excel Help

£0.00 @
Is anyone in here any good with MS Excel? I need help with a problem... I need to search a column of numbers in Excel (A) and compare it to another column (B). I need to find all of the numbers that … Read More
1d, 3w agoPosted 1 decade, 3 weeks ago
Is anyone in here any good with MS Excel? I need help with a problem...

I need to search a column of numbers in Excel (A) and compare it to another column (B). I need to find all of the numbers that apprear in column A but not in column B. Can this be done?

Thanks in anticipation...

Sanchez:-(
1d, 3w agoPosted 1 decade, 3 weeks ago
Options

(6)
#1
07sanchez
Is anyone in here any good with MS Excel? I need help with a problem...

I need to search a column of numbers in Excel (A) and compare it to another column (B). I need to find all of the numbers that apprear in column A but not in column B. Can this be done?

Thanks in anticipation...

Sanchez:-(

I might be able to help you,but im not 100% sure what you mean
#2
try the IF satement

make a new column

=IF(A2=B2,"duplicate","keep")

and drag them down the colum
#3
Cheers guys, i have found my solution now
#4
what was the solution?
#5
I see you found a solution, this may also work:
put your numbers in A nd B, then paste this into C and drag down....

=IF(ISERROR(MATCH(A1,\$B\$1:\$B\$5,0)),A1,"")
#6
=IF( COUNTIF(B:B,A1),"yes","no")