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