Frequency
Hi,
I have a project to count how freq a pair of numbers appear amount A FEW
groups of 6 numbers.
Lets say I have 2 pairs of 6 numbers, (1,2,3,4,5,6) & (1,3,5,7,9) and pairs
(1,3) & (3,5) & (1,5) appears twice in these 2 pairs of 6 numbers. I am
unable to
find a suitable formula for this problem and the nearest I can do is COUNTIF
but COUNTIF can only cater 1 CRITERIA but in these i believe I have 2 or
more.
|