comparing columns finding unique values and duplicates

jgreiling

New Member
Joined
Sep 6, 2008
Messages
2
Hi I am trying to compare two columns. One has the only unique numbers, the other has blanks, text and numbers (some of them more than once).

What I would like to achieve is an output into column C that finds all the numbers from column B, that are also in Column A
and those Numbers that are in A, but not in B (into Column D)
and those that are in B, but not in A. (into Column E)

spaces between the values in columns C to E are o.k

Ideally without a repeat of the duplicates.

f.e
<table x:str="" style="border-collapse: collapse; width: 106pt;" border="0" cellpadding="0" cellspacing="0" width="140"><col style="width: 53pt;" span="2" width="70"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 53pt;" width="70" height="17">
</td> <td class="xl23" style="width: 53pt;" x:num="798257100" align="right" width="70">798257100</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">-AIS-6458</td> <td class="xl23" x:num="798256400" align="right">798256400</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">-AIS-6458</td> <td class="xl23" x:num="798256200" align="right">798256200</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">-AIS-6458</td> <td class="xl23" x:num="798256100" align="right">798256100</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">798247900</td> <td class="xl23" x:num="798256000" align="right">798256000</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">798247900</td> <td class="xl23" x:num="798255700" align="right">798255700</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">798247900</td> <td class="xl23" x:num="798255600" align="right">798255600</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">-AIS-6458</td> <td class="xl23" x:num="798255500" align="right">798255500</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">-AIS-6458</td> <td class="xl23" x:num="798254500" align="right">798254500</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">-AIS-6458</td> <td class="xl23" x:num="798254400" align="right">798254400</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">-AIS-6458</td> <td class="xl23" x:num="798254200" align="right">798254200</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">-AIS-6458</td> <td class="xl23" x:num="798252700" align="right">798252700</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">-AIS-6458</td> <td class="xl23" x:num="798252400" align="right">798252400</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">798252400</td> <td class="xl23" x:num="798251800" align="right">798251800</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">798252400</td> <td class="xl23" x:num="798250500" align="right">798250500</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">798252400</td> <td class="xl23" x:num="798249800" align="right">798249800</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">798252700</td> <td class="xl23" x:num="798250000" align="right">798250000</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl23" x:num="798249000" align="right">798249000</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl23" x:num="798248400" align="right">798248400</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Transport
</td> <td class="xl23" x:num="798248600" align="right">798248600</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl23" x:num="798248800" align="right">798248800</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Shipped
</td> <td class="xl23" x:num="798247900" align="right">798247900</td> </tr> </tbody></table>

I had a look at some of the coding efforts, but none seems to work.

(As the columns are actually on separate worksheets and the final information is to be put onto a new worksheet. This is, as both worksheets are constantly updated)

Thanks
 
Last edited:

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Watch MrExcel Video

Forum statistics

Threads
1,098,984
Messages
5,465,841
Members
406,449
Latest member
malar11567

This Week's Hot Topics

Top