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.
Can you explain better that single part, what I understood was:
Filter column A with equal "Y" and then ? only show the line that has text on coumn B ?
Bookmarks