Skip to main content

All Questions

1 vote
2 answers
2k views

Finding the MAX value over a range but if one row is blank, the value for MAX must be blank

I want to do a MAX value for the latest date in my data for the "Actual" column, but, say that one cell has no date, I want the MAX (in yellow) to be blank too. Any help would be appreciated!...
Se OKane's user avatar