View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dallman Ross Dallman Ross is offline
external usenet poster
 
Posts: 390
Default Conditional SUBTOTAL

Great advice is hard to beat. I get that in this group. Thank you!

I have a column of dates. Another column contains ordinary
integers, positive or negative. I want to find the lowest date
where the offset column is a negative number.

Example:

Col. F Col. G
------ ------
18-Apr-08 -12
14-Apr-08 12
7-Apr-08 -6
1-Apr-08 -24
24-Mar-08 -20
19-Mar-08 18


I'm looking for 24-Mar-08 -- the lowest date where Col. G is
negative. The dates might not always be sorted, in case that
matters. Can someone think of how? I'm stumped.

=dman=