Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Apr 2001
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comparing Lists of Album Titles (2000)

    Hi

    I've tried searching through the archive to solve this problem, but I have insufficient technical knowhow to adapt similar scenarios. If the answer is in there, I apologise, just point me in the right direction.

    We get lists of available albums for sale from record companies. Each week they remove 20 titles and add 20 new ones, but they are not marked. We want to create a list of new titles available. How can I extract this information without manual comparison.

    Thanks
    Lucy <img src=/S/headthrob.gif border=0 alt=headthrob width=15 height=15>

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Comparing Lists of Album Titles (2000)

    Lucy

    If you would think of this in plain English, or whatever language you prefer, you will come to the following conclusion:
    <font color=blue> I want to find the 20 items that are in one list but not the other. </font color=blue>

    So to do that we see that the LookUp functions can help us do that. You have a couple of lookup functions, and the most used one is the VLookup, (stands for Vertical Lookup, vertical means in Columns)

    So check the VLookUp function in the function wizard, and check the attached workbook for examples.

    Wassim
    Attached Files Attached Files
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing Lists of Album Titles (2000)

    Wassim: Why did you array enter that formula, it is not an array formula? It works just fine without array entering it, and array entering it will add considerable additional overhead on every recalc.

    I would also make one small change to the formula so that the cells show blank for the entries that are not new:

    <pre>=IF(ISERROR(VLOOKUP(B2,A:A,1,FALSE)),"New Number","")
    </pre>

    Legare Coleman

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Comparing Lists of Album Titles (2000)

    Legare

    It was not indicated if these entries were unique or not, so I thought of the array formula, after re-reading the post, I don't think this is a huge concideration.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing Lists of Album Titles (2000)

    What would your formula do different if they were not unique?
    Legare Coleman

Posting Permissions

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