Found 5th Jun 2007
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:-(

  1. Misc
Groups
  1. Misc
6 Comments

07sanchez

Is anyone in here any good with MS Excel? I need help with a problem...I … 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

try the IF satement

make a new column

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


and drag them down the colum

Original Poster

Cheers guys, i have found my solution now

what was the solution?

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,"")

Original Poster

=IF( COUNTIF(B:B,A1),"yes","no")
Post a comment
Avatar
@
    Text
    Top Discussions
    1. NEWBIE Help with a new laptop or PC please?!34
    2. Spotify family22
    3. Gala Bingo/Games. Deposit £5 get £40 cashback. Quidco - new Gala members11
    4. Has the amount of Apple fanboys increased on the site after the redesign?11

    See more discussions