Hey,
I have a colum A (in sheet '2174') that have this kind of data:
<colgroup><col></colgroup><tbody>
</tbody>
i want to extract only number that meet this crateria to the main sheet (colum A):
if > 1600000000 and last 3 digits 930 or <1600000000 and last 3 digits are 840.
with out VBA
the result should be like this:
<colgroup><col></colgroup><tbody>
</tbody>
I have tried may options with match and index but couldn't get it right.
please help.
I have a colum A (in sheet '2174') that have this kind of data:
1335001410 |
1335003990 |
1341000930 |
1341001790 |
1341001930 |
1341001990 |
1341002930 |
1341002990 |
1341003930 |
1841060182 |
1841060471 |
1842200760 |
1842201840 |
1842202841 |
1842203840 |
1842203841 |
1842205840 |
1842206840 |
1842207810 |
<colgroup><col></colgroup><tbody>
</tbody>
i want to extract only number that meet this crateria to the main sheet (colum A):
if > 1600000000 and last 3 digits 930 or <1600000000 and last 3 digits are 840.
with out VBA
the result should be like this:
1341000930 |
1341001930 |
1341002930 |
1341003930 |
1842201840 |
1842203840 |
1842205840 |
1842206840 |
<colgroup><col></colgroup><tbody>
</tbody>
I have tried may options with match and index but couldn't get it right.
please help.