Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find in list function
I have two lists that should contain the same values. In Excel, they are in
two columns. In the third column, I want to put the values that are in List A but not in List B. In the fourth column, I want to put the values that are in List B but not in List A. List A is from A1 : A501 List B is from B1 : B458 Can this be done in Excel? |
#2
|
|||
|
|||
How about comparing each item in column A to the range of cells in column B
using the MATCH() function. MATCH() will return an error for match-not-found, which we can detect in ISERROR(). So in C1: =if(iserror(match(A1,b$1:B$458,0)),A1,"") will indicate unmatch items in A. Do something similiar for column B. Good Luck -- Gary's Student "jrup" wrote: I have two lists that should contain the same values. In Excel, they are in two columns. In the third column, I want to put the values that are in List A but not in List B. In the fourth column, I want to put the values that are in List B but not in List A. List A is from A1 : A501 List B is from B1 : B458 Can this be done in Excel? |
#3
|
|||
|
|||
Put this in C1 and copy down.......
=IF(ISNA(VLOOKUP(A1,B:B,1,FALSE)),A1,"") Put this in D1 and copy down.......... =IF(ISNA(VLOOKUP(B1,A:A,1,FALSE)),B1,"") Vaya con Dios, Chuck, CABGx3 "jrup" wrote in message ... I have two lists that should contain the same values. In Excel, they are in two columns. In the third column, I want to put the values that are in List A but not in List B. In the fourth column, I want to put the values that are in List B but not in List A. List A is from A1 : A501 List B is from B1 : B458 Can this be done in Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no show all function in dropdown list in Pivot Table | Excel Discussion (Misc queries) | |||
Creating Drop Down boxes with the List function... | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel | |||
how do i create a find function for an excel drop list? | Excel Discussion (Misc queries) | |||
ISNULL function - can't find it | Excel Worksheet Functions |