Thread: Error comparing and getting result of between Two columns
View Single Post
 
Old 06-18-2014, 06:33 PM
whatsup whatsup is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default
Hi

Use COUNTIF():
=IF(COUNTIF($B$2:$B$12,A2)>0,"Yes","No")
Copy the formula right to the bottom of your list.
Reply With Quote