Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,748
- Office Version
- 365
- Platform
- Windows
I have a very long list of numbers in column A and I would like a code to tell me which numbers are missing from the sequence. Below is an example.
Excel 2010
<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><col></colgroup><thead>
</thead><tbody>
</tbody>
So from above the following numbers are missing so I would like a list of these made in column D.
Excel 2010
<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><col></colgroup><thead>
</thead><tbody>
</tbody>
Thanks
Excel 2010
A | |
---|---|
4565 | SS9822 |
4566 | SS9824 |
4567 | SS9826 |
4568 | SS9828 |
4569 | SS9830 |
4570 | SS9831 |
4571 | SS9833 |
<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><col></colgroup><thead>
</thead><tbody>
</tbody>
So from above the following numbers are missing so I would like a list of these made in column D.
Excel 2010
D | |
---|---|
4565 | SS9823 |
4566 | SS9825 |
4567 | SS9827 |
4568 | SS9829 |
4569 | SS9832 |
<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><col></colgroup><thead>
</thead><tbody>
</tbody>
Thanks
Last edited: