function exists?

  • Thread starter Thread starter Francisco Costa
  • Start date Start date
F

Francisco Costa

Greetings,

In one column I have a list of numbers (1, 3, 5, 6, 7 and
10), in other cell I have a grade (4).
Is there a function that can compare all values of the
column with the cell, and put ONLY the first greater
number in a nearby cell?

Thanks,
Francisco
 
Francisco Costa said:
Greetings,

In one column I have a list of numbers (1, 3, 5, 6, 7 and
10), in other cell I have a grade (4).
Is there a function that can compare all values of the
column with the cell, and put ONLY the first greater
number in a nearby cell?

Thanks,
Francisco
Click to expand...

Suppose your list is in A1:A6 and your grade in B1. Try this formula:
=MIN(IF(A1:A6>$B$1,A1:A6))
This has to be array-entered. Use CTRL+SHIFT+ENTER rather than just ENTER.
 
With your numbers in A1:A20 in ascending order, and your grade value in C5, then in say D5 you
could use:-

=INDEX($A$1:$A$20,MATCH($C$1,$A$1:$A$20)+1)
 
Not function per say but formula

=INDEX(A1:A10,MATCH(SMALL(A1:A10,COUNTIF(A1:A10,"<"&C1)+1),A1:A10,0))

where A1:A10 is your numbers and C1 holds the lookup (4 in your example)
 
Francisco:

If list is in cells A1:A6 and lookup value is in B1. Use
the following:

=INDEX($A$1:$A$6,MATCH(B1,$A$1:$A$6,1)+1)

Regards,
Felipe
 
Back
Top