In Excel, how can I count how many times one value appears in the same row as another value. for example in this array, how many times does 5 appear with 6. I can see its 3 times but need a formula to count it for me
5 6 12 13 22 35
1 10 25 33 35 2
4 9 10 20 33 2
1 7 10 16 24 1
1 5 6 18 30 22
9 11 14 28 33 5
1 6 15 25 28 5
7 10 17 22 34 7
No comments:
Post a Comment