View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Krill
 
Posts: n/a
Default 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