Hi Max,

Sorry I forgot to mention one other important things which will throw
a monkey wrench into our calculations.

The new list (Sheet2) has two things done to it.
1. New students have been added to it and the list sorted alpha.
2. Some 50+ students have been deleted.

So.... I need placeholders for those students who have been deleted.
The placeholders can be something like "Deleted" for each deleted
record.
I'm hoping there's a way to do this.

Thanks! Eric