I have a very large worksheet. I am trying to delete whole rows of data if a cell does not contain a value.

My range is AY1:AY46000
The values in that column are 6 digits, like 123456, 123457, 123458 and so on.
I want to keep all that start with 5013, 5014, and 5015.

Any clue? Thanks in advance!