Skip to main content

Hi Guys

 

i have a workbook with same data showing a list of full names, i need to create some kind of a calculation field which will show me the number of names where the first name starts with either an "A" or an "E"

 

how can this be done?

 

thank you for any help

2 answers
  1. Aug 7, 2019, 1:23 PM

    this

     

    this will return this or this JimIf this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question.

     

    will return this

    pastedImage_1.png

     

    or this

    pastedImage_2.png

     

    Jim

    If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

0/9000