count if the two cells are equal
One way:
=SUMPRODUCT(--(A1:A10=B1:B10))
Adjust ranges to the real size of columns!
Regards,
Stefi
€žsdwilson€ť ezt Ă*rta:
What do I use if I have two collums of data and I want to count how many of
them are the same
ie - A1 has a value of 1.1 while B1 has a value of 1.1
A2 has a value of 1.2 while B2 has a value of 1.4
I want the function to tell me that out of those two - one of those valus
remain the same in the next
|