powercell99
Board Regular
- Joined
- May 14, 2014
- Messages
- 75
I use an array MIN formula too give me the earliest date from a set of data meeting one criteria. The dates are formatted as dates. ex: {=MIN(IF($D$2:$D$2222=$D2,$M$<wbr>2:$M$2222 ))}
It works flawlessly and i understand what its doing. But when i try to use that method and add a 2nd criteria, it returns 0 as the earliest date.
ex: {=MIN(IF(AND($D$2:$D$2222=$D2, $G$2:$G$2222=$G2),$M$2:$M$2222))}
Logically, that should work if i understand what the Array MIN formula with 1 criteria is doing. But it doesn't work.
{=MIN(IF(AND($D$2:$D$2222=$D2, $G$2:$G$222=$G2),$M$2:$M$2222))}
I've read on some other pages to try:
{=MIN(IF($D$2:$D$2222=$D2,IF($G$2:$G$2222=<wbr>$G2, $M$2:$M$2222,"")))}
But that doesnt seem to work either, AND i cant understand the concept of what that is doing.
Any suggestions? What am i missing????
Any help would be greatly appreciated.
Larry
It works flawlessly and i understand what its doing. But when i try to use that method and add a 2nd criteria, it returns 0 as the earliest date.
ex: {=MIN(IF(AND($D$2:$D$2222=$D2, $G$2:$G$2222=$G2),$M$2:$M$2222))}
Logically, that should work if i understand what the Array MIN formula with 1 criteria is doing. But it doesn't work.
{=MIN(IF(AND($D$2:$D$2222=$D2, $G$2:$G$222=$G2),$M$2:$M$2222))}
I've read on some other pages to try:
{=MIN(IF($D$2:$D$2222=$D2,IF($G$2:$G$2222=<wbr>$G2, $M$2:$M$2222,"")))}
But that doesnt seem to work either, AND i cant understand the concept of what that is doing.
Any suggestions? What am i missing????
Any help would be greatly appreciated.
Larry
