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 ...

How to Extract a Substring in Excel Using FIND() and MID() Functions Your email has been sent Learn how to use MID() and FIND() and then combine them to parse substrings from inconsistent data.

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, data summaries created via PIVOTBY automatically update to reflect changes ...

Have you ever found yourself wrestling with Excel, trying to make sense of endless rows and columns of data, only to be let down by outdated functions like VLOOKUP or HLOOKUP? You might be interested ...