Thread: Help with Formula
View Single Post
 
Old 06-24-2017, 08:18 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
In C2:

=IF(COUNTIF($B$2:$B$15;B2)=2,TRUE,"")

Copy down.
Reply With Quote