number list compare

J

jpmmschi

How do a compare a number to a list of numbers to get the next highest and
next lowest number?
 
D

Domenic

jpmmschi said:
How do a compare a number to a list of numbers to get the next highest and
next lowest number?
Click to expand...

Assuming that your list of numbers are in Column A...

Next lowest number:

=MAX(IF(A1:A10<B1,A1:A10))

Next highest number:

=MIN(IF(A1:A10>B1,A1:A10))

....where B1 contains the number being compared to. Both these formulas
need to be entered using CONTROL+SHIFT+ENTER.

Hope this helps!
 
Top