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:

    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!