closest or nearest value (higher or equal)

[vysa]

Hello
Supposing you have a list of numbers in a column, and now you are required to find out the closest or nearest value(higher or equal) to a given value from the list of numbers.
How do you deal with it?
Book1.xlsx

[protonLeah]

Sort column A Largest to smallest and use:

Please Login or Register  to view this content.

[HansensOffice]

If I understand what you are after, the closest value is 108.

[martindwilson]

in an unsorted range try =small(a1:a62,countif(a1:a62,"<"&d1)+1)

[vysa]

I need higher or equal, can not be less

[Tony Valko]

One way if using Excel 2010 or later...

=AGGREGATE(15,6,A1:A62/(A1:A62>=D1),1)

[vysa]

Thanks martindwilson,
seems that is works