Adjusting numbers to nearest preferred number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BRob - 01 May 2008 10:18 GMT

I've a named and sorted range of integers (called 'ScalePts') - about 20 in
total.

I've a set of numbers in Column E (about 600).

In Column F, I'd like to put in the value from 'ScalePts' that is closest to
the column E value.

Can SKS help.

TIA

Rob

Reply to this Message

Niek Otten - 01 May 2008 11:16 GMT

Hi Rob,

Look here:

http://www.cpearson.com/excel/TablesAndLookups.aspx

section Closest Match Lookup

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| I've a named and sorted range of integers (called 'ScalePts') - about 20 in
| total.
[quoted text clipped - 9 lines]
|
| Rob

Reply to this Message