View Single Post
  #1   Report Post  
redeucer
 
Posts: n/a
Default 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?