Hi,
This formula Determines if “A” is present anywhere in the range R6:R303 and returns the value (a date) in cell B2 if it is.
If A is not present it returns the earliest date.
=IF(COUNTIF(R6:R303,"*"&"A"&"*"),$B$2,MIN(R6:R303))
The problem is if there is no data at all in the range it returns 00-Jan-00.
How can I modify the formula so that it returns nothing if the range is empty (except for formulas)?
Thanks very much
Dave
Bookmarks