Excel Help - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Excel Help

07sanchez Avatar
9y, 7m agoPosted 9 years, 7 months 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:-(
07sanchez Avatar
9y, 7m agoPosted 9 years, 7 months ago
Options

All Comments

(6) Jump to unreadPost a comment
Comments/page:
#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")

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!