Somebody explain me this formula please. I need your help
=IF(E3=0;"";IF(COUNTIFS(G:G;G3;AD:AD;">="&AD3;AD:AD;"<="&AE3)>1;"WRONG";"OK"))
<tbody>
</tbody>
=IF(E3=0;"";IF(COUNTIFS(G:G;G3;AD:AD;">="&AD3;AD:AD;"<="&AE3)>1;"WRONG";"OK"))
G | AD | AE | |
10000571 | 13/12/2018 15:30 | 13/12/2018 19:30 | OK |
10000571 | 13/12/2018 15:30 | 13/12/2018 19:30 | OK |
11500834 | 06/12/2018 15:00 | 06/12/2018 21:00 | WRONG |
| | | |
|
<tbody>
</tbody>