Error comparing and getting result of between Two columns

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

FAQ

Thread Tools

Display Modes

06-18-2014, 07:35 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

That way:

=IF(A2="","Empty",IF(COUNTIF($B$2:$B$12,A2)>0,"Yes","No"))
The example sticks to the first description of yours, somehow you got the sample-list mixed up

« Previous Thread | Next Thread »

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:21 PM.