View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Two-Canucks
 
Posts: n/a
Default 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