Q: Compare two columns and get percentage of cells that match
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)
Posted on Sep 14, 2016 10:16 AM
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)
Posted on Sep 14, 2016 12:17 PM
