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.
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.