Rialtus (rialtus) wrote,

Excel: Identify duplicate items on two columns

You have two columns of data. They can be on different sheets for all I care. You want to identify the duplicate information -- datum on one column that is also in the second column.

This example gives the assumption that column A has one column of data, and the other listing of data has the named area of "List". (To create named area, highlight info, Insert, Name, Define). Using column B, enter the following equation: =VLOOKUP(A1,list,1,FALSE)

If there is a match, you will see the matching information. If there is no match, you will see the "#N/A" error.
Tags: excel, reference

  • Could have been worse...

    Kelson Vibber made an interesting post - What would have happened if this quake happened during Comic-Con this past weekend? Pure pandimonium if it…

  • Earthquake

    Wife is fine. Parents are fine. Right now it's being called a 5.8 based in Chino Hills. About 45-60 seconds of movement. Still in downtown LA.…

  • I feel the earh move under my feet

    Have we heard from calliaume or teppanyaki yet? jumbach - See, *that* is an earthquake, especially given where…

  • Post a new comment


    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 1 comment