Hi Hans,

Am Mon, 18 Nov 2013 08:01:44 -0800 (PST) schrieb
:

"Yes" means no error and "NO" means one or more errors.
The table is dynamic and gets data from underlying tables.

Date Check
05. nov 2013* Yes
06. nov 2013* Yes
07. nov 2013* Yes
08. nov 2013* No

try:
=MAX(LARGE((B2:B1000<"Yes")*(B1:B999="Yes")*ROW(1 :999),ROW(1:999))-LARGE((B2:B1000="Yes")*(B1:B999<"Yes")*ROW(1:999) ,ROW(1:999)))
and array-enter the formula with CTRL+Shift+Enter


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2