Excel formulas 201... August 1, 2008 5:20 PMSubscribe

Intermediate level Excel formula question.... Say I have a column with an array of dates in order and a matching column with an array of values. I need a formula that outputs the date at which one of the values first falls below a certain number.

For example. Let's say I have in rows 1-5 and columns A-B...

For the first smallest date:
=small(if(b1:b7>21,a1:a7),1) and ctrl+shift+enter
For the second:
=small(if(b1:b7>21,a1:a7),2) and ctrl+shift+enter posted by milkrate at 5:30 PM on August 1, 2008

Thank you SO much, milkrate.. That was awesome! posted by drpynchon at 9:19 PM on August 1, 2008

« Older What kind of influence do US n... | Easiest/quickest way to get fr... Newer »

=small(if(b1:b7>21,a1:a7),

1) and ctrl+shift+enterFor the second:

=small(if(b1:b7>21,a1:a7),

2) and ctrl+shift+enterposted by milkrate at 5:30 PM on August 1, 2008