Hey Vj2k;

So, in Excel 2011, there is a remove duplicates function in the Data Ribbon Tab. What this will do is remove all repeat instances of data for your criteria... But, you're making it a little more complex with potentially having incomplete data in the other columns.

So, I just did some quick testing of the Remove Duplicates option, and what I've found is that it will always keep the first instance that it identifies.

With that in mind, What we can do in this particular instance is add a 5th column that just simply tells us how many previous columns were filled out.

By using a =Counta(a1:e1), pulled down for all 12000 records, it'll flag the complete entries.

From here, sort your data on both the person's name, AND the new Counted field... You want the full counts on the top.

From here, you can remove duplicates on the person's name, and it should only retain the most full entry associated with that person.

I hope this helps, and that you can follow the methodology for the use. Post back if you have anymore questions!