Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Make sure that the headers of the columns of A:D and F:I are exactly the same. Highlight your data in the A:D range and apply the Advanced Filter, specifying the data in the columns of the F:I as a criterion (do not forget to specify the cell of destination in the Options)

OptionsOfAdvFilter

click to hide/show revision 2
No.2 Revision

Make sure that the headers of the columns of A:D A:E and F:I F:J are exactly the same. Highlight your data in the A:D A:E range and apply the Advanced Filter, specifying the data in the columns of the F:I F:J as a criterion (do not forget to specify the cell of destination in the Options)

OptionsOfAdvFilter

Make sure that the headers of the columns of A:E and F:J are exactly the same. Highlight your data in the A:E range and apply the Advanced Filter, specifying the data in the columns of the F:J as a criterion (do not forget to specify the cell of destination in the Options)

OptionsOfAdvFilterOptionsOfAdvFilter