LinkBack URL
About LinkBacks
How do I compare two columns A,B and extract the unique values from B to another column C.
Column comparison
How do I compare two columns A,B and extract the unique values from B to another column C.
Show us some sample data along with the result you expect.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I want to compare these two columns and paste the values that are unique to B in C
Please Login or Register to view this content.
Last edited by avinkris; 08-11-2014 at 11:58 PM.
Show us what results you expect.
the result must be like in column ( I have updated the table above)
do you want to get the unique values in Column A and B to column C ? So your result should be Column C right?
http://www.extendoffice.com/document...o-columns.html
Hope it Helps!
Try this one too..
http://www.get-digital-help.com/2009...array-formula/
Try this Array formula which requires confirmation with Ctrl+shift+Enter instead of just Enter.
in C2
and copy down.Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Ok, looks like you want items from column B that are not in column A.
Data Range
Enter this array formula** in C2:
=IFERROR(INDEX(B:B,SMALL(IF(ISNA(MATCH(B$2:B$14,A$2:A$14,0)),ROW(B$2:B$14)),ROWS(C$2:C2))),"")
** 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.
Last edited by Tony Valko; 08-12-2014 at 02:12 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks