I don't know a lot about excel formula's etc (and what I do know I've figured out from the internet) but I'm creating a flight schedule and want to be able to display only the rows that contain a specific date, which appears either in my "arrival date" column or my "departure date" column within my document.

Apart from conditional formatting - which only highlights my chosen value within the document rather than showing me just the rows that contain that value - is there anyway to do this via a formula that identifies whether the value appears in either column? Then I can just sort based on whether it contains my value or not.

I'm currently using filter columns to sort my info, which is fine if I want to show a specific value in only one column but not if I want to also show the same value in another column at the same time.

Any advice?

Thank you