F
FARAZ QURESHI
Hi,
Data as follows:
A B C
ID1 YES YES
ID2 YES
ID3 YES
ID1
ID4 YES YES
ID2 YES
ID2 YES YES
What formula to be inserted in Column D to result the number of times an ID
in Column A repeats in case where either Column B or C shows "YES"
Desired result:
A B C D
ID1 YES YES 1
ID2 YES 3
ID3 YES 1
ID1 "" (Blank because B & C both are <>"YES")
ID4 YES YES 1
ID2 YES 3
ID2 YES YES 3
Data as follows:
A B C
ID1 YES YES
ID2 YES
ID3 YES
ID1
ID4 YES YES
ID2 YES
ID2 YES YES
What formula to be inserted in Column D to result the number of times an ID
in Column A repeats in case where either Column B or C shows "YES"
Desired result:
A B C D
ID1 YES YES 1
ID2 YES 3
ID3 YES 1
ID1 "" (Blank because B & C both are <>"YES")
ID4 YES YES 1
ID2 YES 3
ID2 YES YES 3