Error comparing and getting result of between Two columns

		Microsoft Office Forums > Microsoft Excel > Excel
Error comparing and getting result of between Two columns

06-18-2014, 06:33 PM

whatsup

Windows 7 64bit Error comparing and getting result of between Two columns

Office 2010 32bit

Competent Performer

Join Date: May 2014

Posts: 137

Hi

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing 2 columns of Text	Berk21	Excel	9	02-03-2012 12:19 PM
Advanced Filter - Comparing Two Columns	apolloman	Excel	5	07-27-2011 04:54 AM
How to compare 2 columns with other two columns in EXECL 2007?	Learner7	Excel	5	06-12-2010 09:54 AM
macro for comparing data from 3 columns and pasting into another worksheet	ashukla	Excel	1	06-24-2009 05:01 PM
Comparing Data	leroytrolley	Excel	1	08-09-2008 08:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:34 AM.