Contextures Blog Excel Tips and Tutorials

Excel VLOOKUP Formula Error Mystery http://blog.contextures.com/ 3

Excel VLOOKUP Formula Error Mystery

Someone sent me a workbook in which a simple VLOOKUP formula was returning #N/A errors, instead of the correct results. The product numbers looked the same, but Excel didn’t match them in the lookup....

Problem Grouping Pivot Table Items http://blog.contextures.com/ 0

Problem Grouping Pivot Table Items

If you try to group pivot table items in Excel, you might get an error message that says, “Cannot group that selection.” For older versions of Excel, if you had a problem grouping pivot...

Count Items in a Cell with SUBSTITUTE http://blog.contextures.com/ 0

Count Items in a Cell with SUBSTITUTE

Do you use Excel’s SUBSTITUTE function very often? It’s a handy way to count items in a cell, when they’re separated by commas or spaces. The examples below show different ways to use this...

Excel Roundup http://blog.contextures.com/ 0

Excel Roundup 20171214

Here is an end-of-the-year Excel Roundup, with articles that I’ve read recently. To get weekly links and articles, sign up for my weekly Excel newsletter. Merry Christmas, and happy holidays, and come back for...

Beyond the Rules for Excel Names http://blog.contextures.com/ 2

What Are the Rules for Excel Names?

As Juliet famously said to Romeo, “What’s in a name?” And she was talking about rows (misspelled as “rose”), so maybe Juliet was using a spreadsheet at the time. There are special rules for...

Excel Holiday Planner http://blog.contextures.com/ 2

Excel Holiday Planner Workbook

Long ago, I created a Christmas planner in Excel, and it has evolved over the years. Well, tomorrow is the first of December, so you’ve probably finished your planning for this year. But, if...

Do You Still Need Excel Subtotals? http://blog.contextures.com/ 3

Do You Still Need Excel Subtotals?

Excel has a SUBTOTAL function, which ignores hidden or filtered rows. There is a Subtotal feature too, that quickly groups your data, and adds one or more rows of subtotals. Do we still need...