sjames1066
New Member
- Joined
- Apr 17, 2013
- Messages
- 3
Hi all,
Help would be gratefully received in my current excel dilemma.
In my sheet I'm looking for a formula which gives me either 1 or 2 initials of a first name depending on whether the surname appears more than once and if the first name has the same first letter i.e.
<tbody>
</tbody>
=IF(COUNTIFS(B:B, B16>1,C:C, LEFT(INDEX(C:C, MATCH(C16,C:C,0),0),1)), LEFT(C16, 2), LEFT(C16, 1))
Thanks,
SJ
Help would be gratefully received in my current excel dilemma.
In my sheet I'm looking for a formula which gives me either 1 or 2 initials of a first name depending on whether the surname appears more than once and if the first name has the same first letter i.e.
B Surname | C Firstname | D Initial |
Bloggs | Timothy | T |
Bloggs | Rebecca | R |
Jones | Bill | Bi |
Jones | Bob | Bo |
<tbody>
</tbody>
=IF(COUNTIFS(B:B, B16>1,C:C, LEFT(INDEX(C:C, MATCH(C16,C:C,0),0),1)), LEFT(C16, 2), LEFT(C16, 1))
Thanks,
SJ
Last edited: