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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 03:56 PM.