Hello,

I need to extract data from a spreadsheet (eg below) to another spreadsheet without using the database capabilities in Excel...which probably means using functions/formulas. Whilst it's easy to get the data into the second spreadsheet I end up with lots of blank lines where the unwanted records were located in the first spreadsheet. How do I get around this?

Eg of data in first spreadsheet:

DATE COUNTRY DATA
10/04/05 Syria xxxx
15/05/05 Kuwait xxxx
21/04/05 Yemen xxxx
12/05/05 Oman xxxx
04/04/05 Syria xxxx

I need to be able to specify a date range and extract particular countries within those dates. For example between 01/04/05-30/04/05 I want the data with Yemen and Syria so that the output in the second spreadsheet looks like:

10/04/05 Syria xxxx
21/04/05 Yemen xxxx
04/04/05 Syria xxxx

Any suggestions would be hugely appreciated.

Regards

Tim