Hi,

Hopefully somebody can point me in the right direction on this one..

I am porting a pretty large Google Spreadsheet app over to Excel 2007 for reasons too numerous to go into (Google collaboration alone just not worth it!!).

With Google I was able to use a single formula placed in a single cell (e.g. below) to generate a filtered version of an expansive table on a new sheet.


=filter(Bookings!A:W, Bookings!P:P=C2, Bookings!X:X = "Update Pending / Scoring Error")
However, the Filter() function is not available in XL2007.

Can anybody perhaps suggest an alternative function / most expedient workaround to achieve the same functionality in the Excel version?

Many thanks in advance.
Orson.