number list compare

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do a compare a number to a list of numbers to get the next highest and
next lowest number?
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

looking up a number 4
Compare Cells of Text and Return Highest Value based on a Customiz 1
Formatting cells 2
=average - eliminate the top and bottom number 5
Reversing the order of data separated by commas within a cell? 5
Need a formula for a descimal integer into a whole number 1
Excel finding top of range 1
Divide variable numbers into groups 2

Back
Top