HI guys,
i need to count how many times a combination of two numbers appears in a 5-column array.
the formula used in the result cells is this :
=COUNTIFS(A2:E9,"="&F2,A2:E9,"="&G2)
In that purpose all result cells should show 1.
Any ideas to achieve that?
thank you.
i need to count how many times a combination of two numbers appears in a 5-column array.
the formula used in the result cells is this :
=COUNTIFS(A2:E9,"="&F2,A2:E9,"="&G2)
In that purpose all result cells should show 1.
Any ideas to achieve that?
thank you.