Okay, I have 2 columns containing a lot of the same data, but they alos have
different data. Essentially I am trying to match up the ones that match, and
have a record somewhere else in the sheet of the ones that did not have
partners, and what columns they were from. Here is an example.

LOC_I ITEM_I COMCODE ONHAND_Q PRIM_WH_SEC_C $$ on Hand REEL
223 100047018 100047018 360 1C07E1 280.8 N
223 100050442 100202928 76 1B31C1 82.08 N
223 100202928 100203272 8 1B08C2 28.48 N
223 100203272 100414770 143 1B25F1 180.18 N
223 100203348 100959279 553 1A06D1 474.7 N
086 100203363 100959899 4 P024B3 10.2 N
Now I need columns B and C to match up the ones that are the same, without
chaning the data in the rest. Column 'C' can move, but all the others must
stay the same. Any suggestions.