Excel Finding duplicate in columns

    Hi,
    I have a Column A with part numbers, than I have Column B also with part numbers, but they are lees than part numbers in Column A. Some of the numbers in Column B are the same as in A. How to match both columns and see which numbers exist in both of them?
    Or is there any way to sort numbers in Column B to go next to number in Column A?


    Thanks for your help.

    Re: Excel Finding duplicate in columns


    You can put a formula in Column C that tells you that there is a match found in column A for the part in column B.


    Try in Column C:
    [COLOR="#0000FF"]
    =Isnumber(Match(B2,A:A,0))[/COLOR]


    copied down.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login