How do I find the first value in a column less than a number?
What I have is a large number of cells (more than 7 so nested IF isn't an
option) that I need to find the first value that is less than a number. For
example:
41
21
78
24
90
55
31
36
62
10
88
44
etc.
And I want to display the first number under 20 (which is 10). How would I
do this?
|