|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 1st 08, 10:18 AM
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 
|
| Ads |
|
#2
May 1st 08, 11:16 AM
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 | | |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel. How to round a number to nearest half number? | HaraldS | Excel Discussion (Misc queries) | 2 | February 19th 07 09:50 AM |
| Can you round up numbers to the nearest multiple of ten? | Tilly | Excel Worksheet Functions | 3 | June 5th 06 03:52 PM |
| preferred app? | nastech | Excel Discussion (Misc queries) | 0 | November 25th 05 03:16 PM |
| Rounding numbers to the nearest 5 or 0 | Fieldmedic | Excel Worksheet Functions | 3 | July 17th 05 06:51 AM |
| round numbers to the nearest quarter? | LeelooIvy | Excel Worksheet Functions | 3 | May 14th 05 07:34 PM |
Linear Mode
