padmanabham
New Member
- Joined
- Dec 19, 2014
- Messages
- 16
Hi,
Formula needed as per below inputs
Sheet 1
[TABLE="width: 151"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]A1[/TD]
[TD]B1[/TD]
[/TR]
[TR]
[TD]From[/TD]
[TD]To[/TD]
[/TR]
[TR]
[TD]435190[/TD]
[TD]435200[/TD]
[/TR]
[TR]
[TD]416401[/TD]
[TD]416409[/TD]
[/TR]
[TR]
[TD]437932[/TD]
[TD]437960[/TD]
[/TR]
[TR]
[TD]435328[/TD]
[TD]435365[/TD]
[/TR]
[TR]
[TD]438001[/TD]
[TD]438046[/TD]
[/TR]
[TR]
[TD]435254[/TD]
[TD]435278[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2 - in A1 should come output as per below
[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]435190[/TD]
[/TR]
[TR]
[TD="align: right"]435191[/TD]
[/TR]
[TR]
[TD="align: right"]435192[/TD]
[/TR]
[TR]
[TD="align: right"]435193[/TD]
[/TR]
[TR]
[TD="align: right"]435194[/TD]
[/TR]
[TR]
[TD="align: right"]435195[/TD]
[/TR]
[TR]
[TD="align: right"]435196[/TD]
[/TR]
[TR]
[TD="align: right"]435197[/TD]
[/TR]
[TR]
[TD="align: right"]435198[/TD]
[/TR]
[TR]
[TD="align: right"]435199[/TD]
[/TR]
[TR]
[TD="align: right"]435200[/TD]
[/TR]
[TR]
[TD="align: right"]416401[/TD]
[/TR]
[TR]
[TD="align: right"]416402[/TD]
[/TR]
[TR]
[TD="align: right"]416403[/TD]
[/TR]
[TR]
[TD="align: right"]416404[/TD]
[/TR]
[TR]
[TD="align: right"]416405[/TD]
[/TR]
[TR]
[TD="align: right"]416406[/TD]
[/TR]
[TR]
[TD="align: right"]416407[/TD]
[/TR]
[TR]
[TD="align: right"]416408[/TD]
[/TR]
[TR]
[TD="align: right"]416409[/TD]
[/TR]
[TR]
[TD="align: right"]437932[/TD]
[/TR]
[TR]
[TD="align: right"]437933
[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance.
Formula needed as per below inputs
Sheet 1
[TABLE="width: 151"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]A1[/TD]
[TD]B1[/TD]
[/TR]
[TR]
[TD]From[/TD]
[TD]To[/TD]
[/TR]
[TR]
[TD]435190[/TD]
[TD]435200[/TD]
[/TR]
[TR]
[TD]416401[/TD]
[TD]416409[/TD]
[/TR]
[TR]
[TD]437932[/TD]
[TD]437960[/TD]
[/TR]
[TR]
[TD]435328[/TD]
[TD]435365[/TD]
[/TR]
[TR]
[TD]438001[/TD]
[TD]438046[/TD]
[/TR]
[TR]
[TD]435254[/TD]
[TD]435278[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2 - in A1 should come output as per below
[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]435190[/TD]
[/TR]
[TR]
[TD="align: right"]435191[/TD]
[/TR]
[TR]
[TD="align: right"]435192[/TD]
[/TR]
[TR]
[TD="align: right"]435193[/TD]
[/TR]
[TR]
[TD="align: right"]435194[/TD]
[/TR]
[TR]
[TD="align: right"]435195[/TD]
[/TR]
[TR]
[TD="align: right"]435196[/TD]
[/TR]
[TR]
[TD="align: right"]435197[/TD]
[/TR]
[TR]
[TD="align: right"]435198[/TD]
[/TR]
[TR]
[TD="align: right"]435199[/TD]
[/TR]
[TR]
[TD="align: right"]435200[/TD]
[/TR]
[TR]
[TD="align: right"]416401[/TD]
[/TR]
[TR]
[TD="align: right"]416402[/TD]
[/TR]
[TR]
[TD="align: right"]416403[/TD]
[/TR]
[TR]
[TD="align: right"]416404[/TD]
[/TR]
[TR]
[TD="align: right"]416405[/TD]
[/TR]
[TR]
[TD="align: right"]416406[/TD]
[/TR]
[TR]
[TD="align: right"]416407[/TD]
[/TR]
[TR]
[TD="align: right"]416408[/TD]
[/TR]
[TR]
[TD="align: right"]416409[/TD]
[/TR]
[TR]
[TD="align: right"]437932[/TD]
[/TR]
[TR]
[TD="align: right"]437933
[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance.