excel name lists which change order and size

[cdub000]

I have a list of names in Column B which has the possibility of changing order if the list gets a new name based on meeting a criteria. These list of names are used to determine who has achieved an award. I need a way of keeping track of when an award was given to this individual. Because the list has the possibility of "growing" in size or names changing order I can't just highlight the cell with the name in it because the name may then be in another cell the next time. So is true if I add a column of dates next to the name.

Anyone have a method of keeping track which name has received an award? I was thinking I could create another list of names from the list that changes and grows but I'm not sure how to create a list of names and all new names are added to the bottom of the list. Any ideas?

[TABLE="width: 500"]
<tbody>[TR]
[TD]Names
[/TD]
[TD]Names (next time I open excel)
[/TD]
[/TR]
[TR]
[TD]name1
[/TD]
[TD]newname
[/TD]
[/TR]
[TR]
[TD]name2
[/TD]
[TD]name1
[/TD]
[/TR]
[TR]
[TD]name3
[/TD]
[TD]name2
[/TD]
[/TR]
[TR]
[TD]name4
[/TD]
[TD]name3
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]name4
[/TD]
[/TR]
</tbody>[/TABLE]


Any ideas or help would be appreciated

 

[cdub000]

Any thoughts?