![]() The top cell in each criteria column must be the same as the headers in the columns you want to filter by. In this example, I created the criteria in cells G1 through H2. To use the Advanced Filter to filter with multiple criteria, you need to create a criteria range. ![]() You could also use the Remove Duplicates button on the DATA tab, depending on what you want to achieve, because this will delete duplicate records, not just filter them. On the worksheet, select the column you want to use to filter for unique records. In the Advanced Filter dialog box, click the List range. To filter so that tea displays only once, on the DATA tab, click Advanced. You can use the Advanced Filter to create more powerful filters, such as filtering for unique records and using operators such as OR. ![]() We filtered with the AutoFilter in the AutoFilter details video. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |