How to use the UNIQUE() function to return a count of unique values in Excel Your email has been sent The TechRepublic article How to create a sorted unique list in an Excel spreadsheet shows you how ...

There are a few ways to count the number of items in an Excel list, depending on the data you have. In this tutorial, learn how to count items in Excel using the COUNTIF and SUBTOTAL functions. Image: ...

Data is rarely properly formatted and structured when you import it. Try these eight tips for fast data cleanup in Microsoft Excel. Data comes in from an increasing number of sources these days. For ...

You can remove duplicates in Excel in a few steps; duplicates can create problems when you're dealing with data. Excel provides an easy tool that removes duplicate values for you, but it can only ...