Greetings:
I hope someone has the patience to help work the following thru with me.
(assuming my descriptions make sense)

I'm looking to do something like the following:
Check Cell A2; Determine how many rows down are exactly same as A1;
Select A2 down to last equal cell and across all columns; Name Range
Within Range: check Column "AZ";
Employee number to be identical in each cell of column AZ, within that range.

If NOT, delete complete range. Process same procedure on next Range.
If YES, then leave complete range alone, and continue to next Range and
repeat process.
SAMPLE
A AZ
1 Job # Employ #
2 2489 113
3 2489 113
4 2489 228
5 2489 113
6 2650 220
7 2650 295
8 2650 331
9 2722 222
10 2722 222

1st range would be A2 / AZ5: (all the same Job Number)
The range would be deleted, since there is more than one employee identified
on that job
2nd range: A6 / AZ8: All Same Job Numbers, but, again more than one employee.
Delete that range, as well
3rd Range: A9 / AZ10: Same job number - Only ONE employee listed on that
job.
Keep the range intact, and move onto next range (which would be A11 / AZ ???

Etc.,........., until there are no more rows to process.

Any help would be greatly appreciated.