Error comparing and getting result of between Two columns

shilabrow · #1 06-18-2014, 06:54 PM

Thanks Whatsup - Works great! But how do I make the formula give me an empty cell if I copy the formula way below the last cell with ID so that the formula can capture new IDs as they are coming in without showing me No until it sees an ID.

Like saying If No IDs in any Cell B (B5) I get "empty" rather than No. Thanks!!

whatsup · #2 06-18-2014, 07:35 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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