#### 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: