Displaying a list of names matching specific criteria

[gary_parker]

Hi again

I'm looking into simplifying a register that we have here at my company (i'm on night shift and very bored).

I'm looking for a formula that will display the names of staff that have a certain character next to their name. For example, in a list of 20 staff, 5 would have a "C" for Customer Services next to them. I would like a formula that finds those staff and lists them in a column, is this possible?

KR

Gary

 

[PA HS Teacher]

You could add a columun with:
=Left(B1,1) pasted down.

Then do an autofilter for "C" on this new column.