LinkBack URL
About LinkBacks
Hi all,
Have 2 lists (column A, and B).
I am to find out what values are in column B, but NOT in column A.
Please see attached.
Hi all,
Have 2 lists (column A, and B).
I am to find out what values are in column B, but NOT in column A.
Please see attached.
How about a simple COUNTIF() function. Something like =COUNTIF($A$1:$A$50,B1) (note how I used relative and absolute references to make this easy to copy). Any result that is greater than 0 is a value present in both A and B.
Originally Posted by shg
Use Conditional Formatting with, for example,jFormula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Can we get it so the value that isn't in Column B is copied to Column C?
Nest the COUNTIF() function I gave inside of an IF() function maybe?
=IF(COUNTIF(...)=0,B1,"none")
That's the opposite of what you originally asked:
I am to find out what values are in column B, but NOT in column A.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
That's the opposite of what you originally asked:
Let me clarify, need to know what values are in Column B but NOT in column A. Those values should copy over to column C
This array formula** entered in C1:
=IFERROR(INDEX(B:B,SMALL(IF(B$1:B$48<>"",IF(ISNA(MATCH(B$1:B$48,A:A,0)),ROW(B$1:B$48))),ROWS(C$1:C1))),"")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Copy down until you get blanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks