MIN/IF Formula returning a default date, i want to change that

[Alphabex]

See attached.

Cells A4 thru A35 are part of a recap for a much larger data set. Cells A38 thru A342 is an example of the data. Currently, in the data range, if there is nothing to report, our reps will either leave it blank or put "No report". But the recap at the top defaults to a 01/00/00 date. I would like the formula to return "Nothing Reported" when this scenario occurs.

Thank you for your help

[63falcondude]

Try this:

=IFERROR(1/(1/formula),"Nothing Reported") Ctrl Shift Enter

That is:

=IFERROR(1/(1/MIN(IF($B$39:$B$9865=$B5,$A$39:$A$9865))),"Nothing Reported") Ctrl Shift Enter

[MarvinP]

Hi Alphabex,

Try this using a CSE and pull down..

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.