Hey,
I have a colum A (in sheet '2174') that have this kind of data:
[TABLE="width: 79"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]1335001410[/TD]
[/TR]
[TR]
[TD="align: right"]1335003990[/TD]
[/TR]
[TR]
[TD="align: right"]1341000930[/TD]
[/TR]
[TR]
[TD="align: right"]1341001790[/TD]
[/TR]
[TR]
[TD="align: right"]1341001930[/TD]
[/TR]
[TR]
[TD="align: right"]1341001990[/TD]
[/TR]
[TR]
[TD="align: right"]1341002930[/TD]
[/TR]
[TR]
[TD="align: right"]1341002990[/TD]
[/TR]
[TR]
[TD="align: right"]1341003930[/TD]
[/TR]
[TR]
[TD="align: right"]1841060182[/TD]
[/TR]
[TR]
[TD="align: right"]1841060471[/TD]
[/TR]
[TR]
[TD="align: right"]1842200760[/TD]
[/TR]
[TR]
[TD="align: right"]1842201840[/TD]
[/TR]
[TR]
[TD="align: right"]1842202841[/TD]
[/TR]
[TR]
[TD="align: right"]1842203840[/TD]
[/TR]
[TR]
[TD="align: right"]1842203841[/TD]
[/TR]
[TR]
[TD="align: right"]1842205840[/TD]
[/TR]
[TR]
[TD="align: right"]1842206840[/TD]
[/TR]
[TR]
[TD="align: right"]1842207810[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 79"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]1341000930[/TD]
[/TR]
[TR]
[TD="align: right"]1341001930[/TD]
[/TR]
[TR]
[TD="align: right"]1341002930[/TD]
[/TR]
[TR]
[TD="align: right"]1341003930[/TD]
[/TR]
[TR]
[TD="align: right"]1842201840[/TD]
[/TR]
[TR]
[TD="align: right"]1842203840[/TD]
[/TR]
[TR]
[TD="align: right"]1842205840[/TD]
[/TR]
[TR]
[TD="align: right"]1842206840[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 79"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]1335001410[/TD]
[/TR]
[TR]
[TD="align: right"]1335003990[/TD]
[/TR]
[TR]
[TD="align: right"]1341000930[/TD]
[/TR]
[TR]
[TD="align: right"]1341001790[/TD]
[/TR]
[TR]
[TD="align: right"]1341001930[/TD]
[/TR]
[TR]
[TD="align: right"]1341001990[/TD]
[/TR]
[TR]
[TD="align: right"]1341002930[/TD]
[/TR]
[TR]
[TD="align: right"]1341002990[/TD]
[/TR]
[TR]
[TD="align: right"]1341003930[/TD]
[/TR]
[TR]
[TD="align: right"]1841060182[/TD]
[/TR]
[TR]
[TD="align: right"]1841060471[/TD]
[/TR]
[TR]
[TD="align: right"]1842200760[/TD]
[/TR]
[TR]
[TD="align: right"]1842201840[/TD]
[/TR]
[TR]
[TD="align: right"]1842202841[/TD]
[/TR]
[TR]
[TD="align: right"]1842203840[/TD]
[/TR]
[TR]
[TD="align: right"]1842203841[/TD]
[/TR]
[TR]
[TD="align: right"]1842205840[/TD]
[/TR]
[TR]
[TD="align: right"]1842206840[/TD]
[/TR]
[TR]
[TD="align: right"]1842207810[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 79"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]1341000930[/TD]
[/TR]
[TR]
[TD="align: right"]1341001930[/TD]
[/TR]
[TR]
[TD="align: right"]1341002930[/TD]
[/TR]
[TR]
[TD="align: right"]1341003930[/TD]
[/TR]
[TR]
[TD="align: right"]1842201840[/TD]
[/TR]
[TR]
[TD="align: right"]1842203840[/TD]
[/TR]
[TR]
[TD="align: right"]1842205840[/TD]
[/TR]
[TR]
[TD="align: right"]1842206840[/TD]
[/TR]
</tbody>[/TABLE]
I have tried may options with match and index but couldn't get it right.
please help.