Thread
:
occurance of numbers in cell range
View Single Post
#
15
Harlan Grove
Posts: n/a
Harlan Grove wrote...
....
=1+SUMPRODUCT(--((A2:A3&B2:B3&C3:C3)=(A1&B1&C1)))
Typo. that should have been
=1+SUMPRODUCT(--((A2:A3&B2:B3&C2:C3)=(A1&B1&C1)))
Reply With Quote