Adjusting numbers to nearest preferred number
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
|