jtovar3
asked on
I need to See which numbers are missing from two lists in excel
I have a master list of numbers. then i have a list of numbers from barb and from cathy. How can i figure out which numbers are in Barb's list but not Cathy's and which are in Cathy's but not Barbs
I have attached a sample here. I think you would use vlookup?
Thanks!
Comparisons.xls
I have attached a sample here. I think you would use vlookup?
Thanks!
Comparisons.xls
http://office.microsoft.com/en-us/excel-help/use-excel-to-compare-two-lists-of-data-HA001103915.aspx
the following formula works for:
column D
=IF(AND(IFERROR(VLOOKUP(C4 ,B:B,1,FAL SE),"*")<> "*",IFERRO R(VLOOKUP( C4,A:A,1,F ALSE),"*") <>"*"),"Bo th","")
column E
=IF(AND(IFERROR(VLOOKUP(C4 ,B:B,1,FAL SE),"*")=" *",IFERROR (VLOOKUP(C 4,A:A,1,FA LSE),"*")< >"*"),"Bar b's","")
column F
=IF(AND(IFERROR(VLOOKUP(C4 ,B:B,1,FAL SE),"*")<> "*",IFERRO R(VLOOKUP( C4,A:A,1,F ALSE),"*") ="*"),"Cat hy's","")
but i see that you have some values stored as text and some as numbers and this might not work, also not all the values are the same length correct?
column D
=IF(AND(IFERROR(VLOOKUP(C4
column E
=IF(AND(IFERROR(VLOOKUP(C4
column F
=IF(AND(IFERROR(VLOOKUP(C4
but i see that you have some values stored as text and some as numbers and this might not work, also not all the values are the same length correct?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!