Compressing a Range

sdruley

Well-known Member
Joined
Oct 3, 2010
Messages
557
Office Version
  1. 365
Platform
  1. Windows
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:


<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]-->
2614.1645

<colgroup><col width="124"></colgroup><tbody>
</tbody>
</tbody>
2613.6186

<colgroup><col width="124"></colgroup><tbody>
</tbody>

<colgroup><col width="142"></colgroup><tbody>
</tbody>
2631.6523

<colgroup><col width="124"></colgroup><tbody>
</tbody>
2631.6544

<colgroup><col width="124"></colgroup><tbody>
</tbody>
2642.1448

<colgroup><col width="124"></colgroup><tbody>
</tbody>
2644.3525

<colgroup><col width="124"></colgroup><tbody>
</tbody>
2645.5578

<colgroup><col width="124"></colgroup><tbody>
</tbody>
2642.2646

<colgroup><col width="124"></colgroup><tbody>
</tbody>
2633.1251

<colgroup><col width="124"></colgroup><tbody>
</tbody>

<tbody>
</tbody>

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

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
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"?
 
Upvote 0

Forum statistics

Threads
1,214,861
Messages
6,121,969
Members
449,059
Latest member
oculus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top