| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find nearest value
I have a column with diameters in thousands of an inch.
I need to find the nearest equivalent in fractions such as 1/64 1/128. The fractions show as decimals in another column. The fractions format only goes to 1/16 which is not small enough. The match function gives an error. Many thanks -- Occasionally stumped |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use vlookup or other to find the nearest values (<) or interpola | Excel Worksheet Functions | |||
| Rounding to the nearest quarter (decimal) in a Pivot table | Excel Discussion (Misc queries) | |||
| Find and Replace | Excel Worksheet Functions | |||
| Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Threaded Mode
