What dioes E1 & E2 mean?
Please explain.
Try something like this:
With your data in columns A and B
E1: Missing (or any text other than the Col_B column title)
E2: =COUNTIF($A$1:$A$27,B2)=0
(Notice the dollar sign ($) plaement in the formula AND that it refers to
the FIRST DATA ITEM in Col_B)
C1: ListB
Select the Col_B data from B1 to the end of the list
From the Excel main menu:
<data><filter><advanced filter>
Check: Copy to another location
List range: (your already selected Col_B data)
Criteria Range: $E$1:$E$2
Copy to: $C$1
Click the [OK] button
That will create a listing, under C1 of the Col_B items that are not in the
Col_A list.
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"[email protected]" wrote:
> Hello, i nee some help. Im trying to compare
> ListA & ListB to Achieve ListC
> ListC needs to be the resut of numbers missing from ListA & shoiwing in ListB.
> Hope you can help.
>
> ListC i hvae shown here is an example of what i need to see in ListC
>
> listA ListB ListC
> 2005 2005 2010
> 2006 2006 2011
> 2007 2007 2012
> 2008 2008 2017
> 2009 2009 2018
> 2013 2010 2020
> 2014 2011 2022
> 2015 2012 2024
> 2016 2013 2025
> 2019 2014 2026
> 2021 2015 2028
> 2023 2016
> 2027 2017
> 2027 2018
> 2029 2019
> 2030 2020
> 2021
> 2022
> 2023
> 2024
> 2025
> 2026
> 2027
> 2028
> 2029
> 2030
>
>
>
>
**********End Of Post*************
Bookmarks