Hi everybody,
I need your help in formula that counts a group of the same data as one
while having different info in the next column: It is important that it
should count based on column B or C but not A amd if no info in front of a
name then it should not count. The results of each column must be col B = 3,
col C = 4. Please help. Thanks.
col A col B col C
Jack 10 20
Jack 20 10
Jack 45 15
Mary 15
Mary 16
Mary 9
Sam 80 15
Sam 45 12
Sam 15 9
Sam 10 9
Max 10
Max 11
Max 88
Alex 15
Alex 10
Alex 9

Count: 3 4