COUNTIF

[Guest]

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) 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.

 

[Guest]

Dear All,

Can anyone help? thx

stefi,

thanks, wat i mean is I have 20-30 groups of 6 and I need to find out how
often a certain pair appear..

Meaning 1st - 30th group of 6 numbers, pair 1 & 5 appear 20 times...
somethin like tat