Display Names Beginning WIth

[sirdon]

Attached is an excel sheet.

In column A is a list of names.

In Column B i want to display the names that start with A, B, C and/or D

the red font in column B is the outcome i am looking for.

Many thanks

[Richard Buttrey]

Hi,

One way

=IF(CODE(LEFT(A2,1))<=68,A2,"")

[sirdon]

Many thanks. Is there a way to have a formula at the top only and not copy it down?

[Richard Buttrey]

You are showing your Excel version as Excel 2010

If that's out of date and you happen to have Excel 365 then you could use the new

=FILTER(A2:A231,CODE(LEFT(A2:A231,1))<=68)

Otherwise automating it would need a macro to apply the original formula I gave you.

[sirdon]

That works a treat. Many thanks. Sorry to be a pain, just a couple of more questions:

1) What does the number 68 mean?
2) how do i now display it between letters. For example Display C to E??

Many thanks,

[Bo_Ry]

Please try at B2:E2

=FILTER($A$2:$A$231,MATCH(LEFT($A$2:$A$231),MID($B$1:$E$1,11,1))=COLUMNS($B1:B1),"")

[sirdon]

Thanks Bo_Ry. I would still like to see Richard's response to my question(s).

[Richard Buttrey]

Thanks Bo_Ry. I would still like to see Richard's response to my question(s).

My response would only be of use if you have Office 365 Excel - or possible Excel 2019. Have you?

[JohnTopley]

@Richard,
I think OP wants a response to post #5 questions.

[sirdon]

yes i do have excel 365

[JohnTopley]

Can you please you please update your profile to reflect you have 365.

[sirdon]

Done...Sorry about that.

[JohnTopley]

Thank you.