Compressing a Range

[sdruley]

I have a range of numbers that go from 2613 to 2645 and I want to reduce this range to 2625 to 2633. Is there a mathematical technique to do this and still retain the same relative structure of the numbers.
The data follows:

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]

<colgroup><col width="142"></colgroup><tbody>
<!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} x\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]-->

<colgroup><col width="124"></colgroup><tbody>
[TD="class: xl67, width: 124"]2614.1645
[/TD]

</tbody>

</tbody>

[/TD]
[/TR]
[TR]
[TD]

<colgroup><col width="142"></colgroup><tbody>
[TD="class: xl66, width: 142"][TABLE="width: 124"]
<colgroup><col width="124"></colgroup><tbody>[TR]
[TD="class: xl67, width: 124"]2613.6186
[/TD]

</tbody>

[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]

<colgroup><col width="124"></colgroup><tbody>
[TD="class: xl67, width: 124"]2631.6523[/TD]

</tbody>

[/TD]
[/TR]
[TR]
[TD]

<colgroup><col width="124"></colgroup><tbody>
[TD="class: xl67, width: 124"]2631.6544
[/TD]

</tbody>

[/TD]
[/TR]
[TR]
[TD]

<colgroup><col width="124"></colgroup><tbody>
[TD="class: xl67, width: 124"]2642.1448[/TD]

</tbody>

[/TD]
[/TR]
[TR]
[TD]

<colgroup><col width="124"></colgroup><tbody>
[TD="class: xl67, width: 124"]2644.3525[/TD]

</tbody>

[/TD]
[/TR]
[TR]
[TD][TABLE="width: 124"]
<colgroup><col width="124"></colgroup><tbody>[TR]
[TD="class: xl67, width: 124"]2645.5578[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]

<colgroup><col width="124"></colgroup><tbody>
[TD="class: xl67, width: 124"]2642.2646[/TD]

</tbody>

[/TD]
[/TR]
[TR]
[TD]

<colgroup><col width="124"></colgroup><tbody>
[TD="class: xl67, width: 124"]2633.1251[/TD]

</tbody>

[/TD]
[/TR]
</tbody>[/TABLE]

This will probably take vba. There must be some mathematicians out there.
Thanks for any assistance

 

[Rick Rothstein]

I have read your message several times now and, quite truthfully, I cannot figure out what you want for the output from the example data you showed us. Can you post the result you want for the data you posted so we have some idea what you meant by "reduce this range to"?