First time here? Check out the FAQ!
![]() | 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)
![]() | 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)
![]() | 3 | No.3 Revision |
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)