Hi all,
I'm trying to find a formula that counts the entrances in a column that have different entrances in the next column.
For example, if I count how many ship in column "Ship" have Charged and Discharged the result must be 2 (Ships T and B)
Thanks in advance,
Sofia
I'm trying to find a formula that counts the entrances in a column that have different entrances in the next column.
For example, if I count how many ship in column "Ship" have Charged and Discharged the result must be 2 (Ships T and B)
Thanks in advance,
Sofia
Ship | Charges/Discharge |
T | C |
B | D |
S | C |
E | C |
E | C |
E | C |
E | C |
E | C |
E | C |
E | C |
I | C |
B | C |
T | D |