Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COMPARE AND COPY
in C1 put in the formula
=if(countif(B:B,A1)0,A1,"") then drag fill down column C down to row 500. Regards, Tom Ogilvy Tom wrote in message m... I have 2 lists of part numbers, 500 in Column B and 2000 in Column C and I would like to compare the 2 lists and where ever a part number in Column A is duplicated in Column B, I would like for the part number to be copied to the adjacent cell in Column A. See example of outcome below. Thanks, Tom A B C 1 404 150 2 183 409 183 3 257 510 257 4 306 5 400 6 404 257 404 7 409 409 8 510 860 510 9 183 594 10 860 860 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare 2 cells then copy value if they are different | Excel Discussion (Misc queries) | |||
Compare and Copy | Excel Discussion (Misc queries) | |||
compare and copy | Excel Discussion (Misc queries) | |||
Compare and copy | Excel Discussion (Misc queries) | |||
Compare and copy | Excel Worksheet Functions |