Hi,
Input :
2018-01-01 | John | Positive |
2018-01-01 | John | Positive |
2018-01-01 | John | Positive |
2018-01-01 | John | Negative |
2018-01-02 | John | Negative |
2018-01-02 | John | Negative |
2018-01-03 | Siti | Positive |
2018-01-03 | Siti | Negative |
2018-01-03 | Siti | Positive |
Is it possible to count how many Positive/Negative in the same date by the same person. I tried using Multi Row Formula and still cant get the expected output as below.
2018-01-01 John Positive = 3
2018-01-01 John Negative = 1
2018-01-02 John Negative = 2
Thank You.
Solved! Go to Solution.
Hi Neil,
Thank you so much. It works perfectly.