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 |