Hello,
I'm looking to take two columns of data from different tables within the same document, which should have a pretty high percentage of matching checkboxes, and have another cell tabulate the percentage that match. I can's seem to figure out how to do this though it really seems possible.
Any help is greatly appreciated.
Thanks!
iMac, OS X El Capitan (10.11.5)
C1=A1=B1
this is shorthand for... select cell C1, then type (or copy and paste from here) the formula:
=A1=B1
select cell C1, copy
select column C, paste
select cell E2, then type "TRUE"
select cell E3, then type "FALSE"
F2=COUNTIF($C,E2)
F3=COUNTIF($C,E3)
G2=F2÷SUM(F$2:F$3)
G3=F3÷SUM(F$2:F$3)
Thanks, I'm going to try and implement this. I'll post an update if anything goes wrong or gets more complicated.
seems to have done the trick. Thank you.
Compare two columns and get percentage of cells that match
