| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the closest match to a reference number in a row of unsorted
Data is random in nature and unsorted. Generally between 10 and 100, two
decimal precision (see below). How do I find the position of the entry closest a given value, say 45.11 45.54 45.56 45.32 45.5 45.42 45.35 45.46 45.4 44.97 45 45.05 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and match totals Genius Req. this should be easier to read | Excel Worksheet Functions | |||
| Match Closest Results from Data Array | Excel Discussion (Misc queries) | |||
| Match two tables using unique ID number | Excel Discussion (Misc queries) | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Find all cells with a number and mulitply | Excel Discussion (Misc queries) | |||
Threaded Mode
