# Thread: Comparing Lists of Album Titles (2000)

1. ## 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. ## 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

3. ## 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>

4. ## 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

5. ## Re: Comparing Lists of Album Titles (2000)

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

#### Posting Permissions

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