This command requires at least two rows of source data. You cannot use the command on a selection in only one row. Try the ...

This command requires at least two rows of source data. You cannot use the command on a selection in only one row. Try the following:  • If you're using an advanced filter, select a range of cells that contains at least two rows of data. Then click the Advanced Filter command again. • If you're creating a PivotTable report or PivotChart report, type a cell reference or select a range that includes at least two rows of data.