Your problem is that you have no identifying feature, the code "00"
appears in other places also.
Try the attached sheet, and duplicate pairs of columns E-F, G-H into
I-J, K-L etc until you get a full set of numbers in the last column
It may not be perfect, it relies on adding +1 to error out, and if
other has 10 characters with 00 it will pass this test.
Hope this helps
ps, I presume that you know, having copied my formula to B1, C1 ~~~ G1,
H1 of your worksheet, that you can select B1 to H1, and formula-drag the
small + sign to the bottom row of your data to copy all (B1 to H1 etc)
formula.
+-------------------------------------------------------------------+
|Filename: FindNum.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3642 |
+-------------------------------------------------------------------+
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=390453