Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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= |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional subtotal function | Excel Worksheet Functions | |||
conditional subtotal counting | Excel Worksheet Functions | |||
Conditional SUBTOTAL | Excel Discussion (Misc queries) | |||
Is there a command like subtotal but with a conditional? | Excel Worksheet Functions | |||
Is it possible to do a conditional subtotal in Excel? | Excel Worksheet Functions |