One great way to find information within a large block of data is to use the filter in Excel. It allows you to see only certain entries in a column, to view the top or bottom entries, to look specifically for entries starting with a certain letter, and to sort data. This is a great [...]
Tag archives for filter
Filter for Duplicates in Excel
Last week we covered removing duplicates in Excel. This week we’ll tackle filtering for duplicates, and next week I’ll show you how to identify duplicated values or unique values with conditional formatting. Using the Advanced Filter, you can take column or columns and eliminate duplicates to leave only unique values. If you are filtering on [...]
category: Excel
About
The McCombs Technology Training Team helps UT Austin business students, faculty, and staff with their technology resources, and with Microsoft Office. The trainers are Holly Green and Ben Bond.
Jeff Hauger, a previous team member, contributed several blog posts.
