Tough one
 

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.

Tough one
 

You have me quite puzzled. Are we talking about a row sort or not? Perhaps
"before" and "after" sample shots would help your explanation.

"Ben" wrote:

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.

Tough one
 

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

What I need it to look like is this...

LOC_I ITEM_I COMCODE ONHAND_Q PRIM_WH_SEC_C $$ on Hand REEL
223 100047018 100047018 360 1C07E1 280.8 N
223 100202928 100202928 76 1B31C1 82.08 N
223 100203272 100203272 8 1B08C2 28.48 N

I can do it individually, but there are 4000 comcodes that I have to match,
and I do not have that kind of time with this project. Essentially I need
the Comcode column to match to the Item_I column, however, some will not have
matches. I also neeed the other data to stay locked in place with respect to
the Item_I column. Sorry it is not that clear, it is rather complicated and
it is hard for me to explain.

"Kevryl" wrote:

You have me quite puzzled. Are we talking about a row sort or not? Perhaps
"before" and "after" sample shots would help your explanation.

"Ben" wrote:

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.

Tough one
 

Hi Ben,

How about VLookup? Something like this should work:

VLookup(I2, $J$2:$J$8000, 1, False)

You need to insert this in a separate column. I assumed that Item_I is
in column I and starts at index 2 (therefore I2). Also, you may have to
adjust 8000 to whatever the actual number of rows is. Insert it in any
column in row 2 , and drag it down to the last row. If there is a
match, VLookup will return the Comcode, or else #N/A.

Hope that helps.
Steve
www.stkomp.com

Ben wrote:
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

What I need it to look like is this...

LOC_I ITEM_I COMCODE ONHAND_Q PRIM_WH_SEC_C $$ on Hand REEL
223 100047018 100047018 360 1C07E1 280.8 N
223 100202928 100202928 76 1B31C1 82.08 N
223 100203272 100203272 8 1B08C2 28.48 N

I can do it individually, but there are 4000 comcodes that I have to match,
and I do not have that kind of time with this project. Essentially I need
the Comcode column to match to the Item_I column, however, some will not have
matches. I also neeed the other data to stay locked in place with respect to
the Item_I column. Sorry it is not that clear, it is rather complicated and
it is hard for me to explain.

"Kevryl" wrote:

You have me quite puzzled. Are we talking about a row sort or not? Perhaps
"before" and "after" sample shots would help your explanation.

"Ben" wrote:

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.