Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adjusting numbers to nearest preferred number
Hi Rob,
Look he http://www.cpearson.com/excel/TablesAndLookups.aspx section Closest Match Lookup -- Kind regards, Niek Otten Microsoft MVP - Excel "BRob" wrote in message ... | 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel. How to round a number to nearest half number? | Excel Discussion (Misc queries) | |||
Can you round up numbers to the nearest multiple of ten? | Excel Worksheet Functions | |||
preferred app? | Excel Discussion (Misc queries) | |||
Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
round numbers to the nearest quarter? | Excel Worksheet Functions |