Thread: [Solved] Matching the values in two columns A and B and to see if there are common values in both the columns
View Single Post
 
Old 12-29-2016, 12:06 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
..... what, if I use COUNTIF FUNCTION AS "COUNTIF($A$2:$A$9;$B$2:$B$9)=1. I checked entering this changed function of countif but results are not correct. why is this, what is the reason .....

I don't know what you mean.

What the "=1" means I actually tried to explain in the uploaded file, Sheet1!F14:F23.

I wrote "Excel array formulas" in Google and got about 246,000 hits in 0.46 seconds.
Reply With Quote