Generate List of Inactive Projects Using Two Lists

**skoodog** · 03-27-2009, 02:37 PM

Though I'm not an XL newbie, I'm definitely not an expert and am more familiar w/ financial uses than accounting uses (financial equations, solver/goalseek and the like).

Here's what I want to do:

I have two lists of projects.

One list is generated from our A/R Report which contain billing on them - these jobs must stay active.

The other list is all currently open jobs.

Therefore, the third list should be all open jobs w/o billing on them. What is the best way to generate a list based on these stipulations?

Thanks in advance!

**ChemistB** · 03-27-2009, 02:55 PM

Do you want additional information pulled from these two lists for this third list (e.g. billing dates or amounts) or just a list of jobs which are open but have had billing attached to them?

**skoodog** · 03-27-2009, 02:58 PM

Originally Posted by ChemistB

Do you want additional information pulled from these two lists for this third list (e.g. billing dates or amounts) or just a list of jobs which are open but have had billing attached to them?

I want a list of jobs to be closed - so if open jobs is List A and jobs w/ billing is List B, I want a list of jobs on List A that are not on List B.

The Syntax of the two lists will be the same:

Column A: Job Code
Column B: Job Description

Also if there's a quick and easy way to remove duplicates from a list that'd be helpful as multiple invoices are generated for jobs so the List B will generate multiple entries for the same job.