In the attached spreadsheet there are 4 entries. One is for Jody Rogers and three are for Asad Bangash. Can a formula be created that will assign a number to each persons last name? The number would have to be the same when the same name is repeated. The numbers assigned can start at 1.
This would have to be a formula that can be copied and pasted into the entire first row as this spreadsheet will have hundreds of entries.
Thank you.
Bookmarks