sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,421
- Office Version
- 2016
- Platform
- Windows
I'm using this array formula to find the latest date in a range;
In cases where there is no date found I am getting "00/01/1900" - can this be taken out by the formula so I get something like "NO RECORD"?
=MAX(IF('121Save'!$A$2:$A$1000=D20,('121Save'!$C$2:$C$1000)*1))
In cases where there is no date found I am getting "00/01/1900" - can this be taken out by the formula so I get something like "NO RECORD"?