RedOctoberKnight
Board Regular
- Joined
- Nov 16, 2015
- Messages
- 150
- Office Version
- 2016
- Platform
- Windows
Good Morning,
I have 3 columns of names. A is First names, B is Last names, and C is formulated =CONCATENATE(LEFT(A2,1),". ",B2) to join the names together with first Initial.
I have a few people that have the same last names and first initials. I'm trying to figure out a formula so that if there are 2 or more people with the same last name and initial, it will add a 2nd letter to the first name initials.
Thanks,
I have 3 columns of names. A is First names, B is Last names, and C is formulated =CONCATENATE(LEFT(A2,1),". ",B2) to join the names together with first Initial.
I have a few people that have the same last names and first initials. I'm trying to figure out a formula so that if there are 2 or more people with the same last name and initial, it will add a 2nd letter to the first name initials.
Thanks,