Show rows that have value in Column A or Column B?

**excel_unknown** · 05-26-2011, 12:17 AM

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

**TonyB51** · 05-26-2011, 12:34 AM

Hi,

Welcome to the Forum.

It may help if you attach a sample of your spreadsheet, so that we can see how you data is placed.

Use Go Advanced to be able to attach the document with you Reply.

Cheers

TonyB

**excel_unknown** · 05-26-2011, 01:59 AM

Thank you.

So attached is my simplified excel sample.

I have no idea if it's a simple request or impossible, but what I would like is to be able to display only those rows that have a specific value within them.

In my sample for example, I just want to see the flights that arrive or depart on the 25-May-11 (that is therefore only the rows relating to travellers Steve, Robert, Kitty and Sally).

As this value occurs in more than one column, filtering them only allows me to display just the date of arrival or just the date of return.

I'm wondering if there is a formula I could use to identify the value "25-May-11" within b4:b9 OR e4:e9 and sort it based on this?

Is this even possible?