+ Reply to Thread
Results 1 to 2 of 2

Re: Comparing Data Need to Include & Exclude

  1. #1
    Guest

    Re: Comparing Data Need to Include & Exclude

    Well i tried it, i cant make it work.
    Did you try it to see if it worked??? and you got the Results i need
    as shown in list3 ??


    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


    "someone@somedomain.com.invalid" 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
    >
    >
    >
    >





  2. #2
    Ron Coderre
    Guest

    Re: Comparing Data Need to Include & Exclude

    Yes...I tested my posted solution and got the exact results that you expected
    to see (per your post). The results of the Advanced Filter are in Col_C.

    Here's my setup:
    Col_A Col_B Col_C Col_E
    listA ListB ListB Missing
    2005 2005 2010 =COUNTIF($A$1:$A$27,B2)=0
    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

    Try using the above setup in a test worksheet to see if you can figure out
    what's different from your previous results

    Let us know what you discover.
    ***********
    Regards,
    Ron

    XL2002, WinXP


    "someone@somedomain.com.invalid" wrote:

    > Well i tried it, i cant make it work.
    > Did you try it to see if it worked??? and you got the Results i need
    > as shown in list3 ??
    >
    >
    > 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
    >
    >
    > "someone@somedomain.com.invalid" 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
    > >
    > >
    > >
    > >

    >
    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1