View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
V V is offline
external usenet poster
 
Posts: 26
Default How do I find the cell/data the closest/nearest to another data?

Hi everyone!

I'm sorry, I can't find my answer in the general help program.

How do I find the cell or the data from a list, that I cannot sort, the
closest to another data.

e.g. If I have 150 values in a column and I do the average of this column, I
want to know which data or cell is the closest from this average. Thank you
so much!