| 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 |
| 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 | |||
Threaded Mode
