Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Use column L (e.g.) to enter into the first row of data, supposedly row 2, the formula
=AND(A2=F2;B2=G2,C2=H2;D2=I2;E2=J2) and fill it down for all the rows containing data. (Will need some time!) Then create the AutoFilter for column L and only select TRUE there from the dropdown.

BTW: More than 700000 rows of data (10 columns each) is to much for a usable spreadsheet.