ID | Type | Code | Active |
WA01 | REF | 0075T | |
WA01 | REF | 0075T | IP |
WA01 | REF | 0076T | |
WA01 | REF | 0076T | IP |
=AND(COUNTIF(D2:D5,"*")-COUNTIF(D2:D5,LOOKUP(2,1/(D2:D5<>""),D2:D5))=0,D2="",D3<>"")
=AND(COUNTIF(D2:D[COLOR=#ff0000][B]9999[/B][/COLOR][B],[/B][COLOR=#ff0000][/COLOR]"*")-COUNTIF(D2:D[B][COLOR=#ff0000]9999[/COLOR],[/B]LOOKUP(2,1/(D2:D[B][COLOR=#ff0000]9999[/COLOR][/B]<>""),D2:D[B][COLOR=#ff0000]9999[/COLOR][/B]))=0,D2="",D3<>"")