Dates and cells values
"beto" wrote in message
...
How can I get the minimum value from column C for all 8/24/2009 dates in
Column A?
I tried some index and match functions but still doesn't work.
Column A Column B Column C Column D
8/24/2009 12:12:56 AM 113 904
8/24/2009 12:52:56 AM 114 908
8/24/2009 1:32:56 AM 114 907
8/24/2009 2:12:56 AM 112 897
8/24/2009 2:52:56 AM 113 902
8/25/2009 12:13:57 AM 82 654
8/25/2009 12:53:57 AM 81 650
8/25/2009 1:33:57 AM 81 650
8/25/2009 2:13:57 AM 81 650
8/25/2009 2:53:57 AM 81 649
8/25/2009 3:33:57 AM 81 647
8/25/2009 4:13:57 AM 81 646
8/25/2009 4:53:57 AM 81 643
8/25/2009 5:33:57 AM 81 643
8/25/2009 6:13:57 AM 81 647
--
asdf
"T. Valko" wrote:
Try this array formula** :
E2 = lookup date = 8/24/2009
=MIN(IF(A2:A16=E2,C2:C16))
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
--
Biff
Microsoft Excel MVP
Thanks it helped me a lot!,
Another question, What if I have the same data but, instead of finding just
8/24/2009, I want to find the maximum value in the following range of dates:
N1=8/25/2009
N2=8/26/2009
N3=8/27/2009
N4=8/28/2009?
I tried this:
MAX(IF(AND($C$5:$C$45000=N1,$C$5:$C$45000=N2,$C$5: $C$45000=N3,$C$5:$C$45000=N4,$C$5:$C$45000=N5,$C$5 :$C$45000=N6),$F$5:$F$45000)) ?????????????????
??????????????????????
anybody?
|