sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,404
- Office Version
- 2016
- Platform
- Windows
I'm trying to get the earliest date in a column if 2 criteria are met, this doesn't work and I get "00/01/1900");
The dates are in column C - the criteria is that the value in column A is "Base" and the cell in column E is blank.
Anyone?
Rich (BB code):
=MIN(IF(OUTCOMES!$A$2:$A876="Base",OUTCOMES!$E$2:$E876="",OUTCOMES!$C$2:$C876))
The dates are in column C - the criteria is that the value in column A is "Base" and the cell in column E is blank.
Anyone?