View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BRob BRob is offline
external usenet poster
 
Posts: 24
Default 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