Formula to return entire row with multiple conditions.

[MissWorkaholic]

Hi

I have a spreadsheet that has 10 columns (month, year, ward etc) and over 800 rows. On a separate sheet I would like it to display the entire row that have "ward 1", "January" and "2013". I would like this information to omit the rows that do not meet the condition without leaving blank rows.

Can anyone please help?

Many thanks

MissWorkaholic

 

[MissWorkaholic]

Example:
https://dl.dropbox.com/u/78583609/Multi.xls

Ah fantastic! That works now. Thank you very much Robert Mika, you are a star!

 

[Robert Mika]

Ah fantastic! That works now. Thank you very much Robert Mika, you are a star!

You are welcome
Thanks for feedback.