Convert a range of numbers to another range

[anastam]

Hello!

I am needing some help reducing a range of numbers into a smaller range of numbers. My current range is 0-3506 and need that range of numbers converted to 0-20, while maintaining ratio. Looking to see if there is a formula that I can use in cell E10 to drag across remaining cells. Current data in E10 is populated on another sheet in the workbook.

Thank you!

Matrix range.png

[6StringJazzer]

First, the way to map 0-3506 to 0-20 is

=x/175.3

where x is the cell with the original data. If you need integers only then

=ROUND(x/175.3,0)

No idea what you mean by "maintaining ratio."

An image attachment has very little value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that. It will be much easier to understand your problem if you provide your file. This allows us to see and experiment with your data, layout, formulas, code, and possibly attach a file with a completed solution.

Under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.ep-by-step instructions with screen shots[/URL][/B][/U]