VBA Autofilter

[liamfrancis2013]

I have a spreadsheet in which i want to display my information by two conditions.

In column 1 i only want it to filter to "Y"; HOWEVER if column 2 contains ANY text, i want the filter to be ignored and it to display the entire row.

Here's some images of an example sheet below:

1.png
2.png

Thanks,
Liam