listing counted entries

Hello all, I am still trying to solve a big excel problem here.
I have the following kind of table with four colums A B C D:


Willoughby John 57 -22
John by the Sea Mark 44 -23
Byabee Ashley 11 -12
Aby Mike 33 22
Miltonby Fred 15 21

I would like now to list all those entries in a line that have in column A a name ending with "by". Names such as "Byabee" or "John by the Sea" should not be counted though. The result should then be listed in new columns. In other words, the new list should read like this:

Willoughby John 57 -22
Aby Mike 3 22
Miltonby Fred 15 21

Any suggestions / ideas how this could be done? Thank you for your help

Use auto filter (Data > Filter > Auto filter).
Then Click on the dropdown for the name, select CUSTOM, select ENDS WITH, enter by in the next bos.

Mangesh

oh wow.. that easy? Hmmm.. I am so stupid.... yeah, autofilter!!!
Thanks for your reply