Lookup Max and Min Values in a List
Given a number I want to look up what number in a list is just greater and just less than my original number.
Ex. Given number 55 look at the following list of values:
22
33
44
55
66
77
and in one cell return 44 and another 66. Seems easy but I can't get it. Thanks.
Bookmarks