How to create list of differences

[Jeff]

This is for an academic conference program I am working on.

1. After a "Call for Papers" I have an XL sheet containing 400 proposal
submissions for the conference program arranged in columns of "Speaker
Name", "title of Presentation", etc.

2. I also have a second XL sheet containing the 150 proposals that will
be accepted into the conference program. It is a subset of the full list
though it does not contain all the same columns. It does however contain
the columns of "Speaker Name" and "title of Presentation".

Other than doing it manually, is there a way to remove all the rows
contained in #2 (the accepted proposals) from sheet #1 to create a 3rd
XL sheet of those NOT accepted so I can send them regret emails?

I hope I am clear.

Thanks, Jeff

 

[Gord Dibben]

See Chip Pearson's site

http://www.cpearson.com/excel/topic.aspx

Scroll down to the "L" section and see the various topics for working with
lists...............common items, extracting and defining non-common items.


Gord Dibben MS Excel MVP

 

[Jeff]

See Chip Pearson's site

http://www.cpearson.com/excel/topic.aspx

Scroll down to the "L" section and see the various topics for working with
lists...............common items, extracting and defining non-common items.


Gord Dibben MS Excel MVP

Thank you. Will do.

 

[Gord Dibben]

Thanks for the feedback.

Don't lose that URL................invaluable.


Gord

 

[Jeff]

Thanks for the feedback.

Don't lose that URL................invaluable.


Gord

Yes it really is loaded with tips.

Thanks again.