Category: Excel Formulas

Excel COUNTIF Challenge http://blog.contextures.com/ 18

Take the Excel COUNTIF Challenge

Last week, in my Contextures Newsletter, I posted an Excel COUNTIF challenge. There were 100 codes on a worksheet, but when counted, the occurrences for each letter only added up to 99. What was...

Excel Holiday Meal Scheduler http://blog.contextures.com/ 0

Create a Schedule in Excel

This weekend is our Canadian Thanksgiving, and we’ll have 16 people here for dinner. To make sure that all the dishes are ready on time, I’ll create a schedule in Excel for everything that...

Enter Complex Excel Formulas Fast 5

Enter Complex Excel Formulas Fast

On Chandoo’s blog, Hui is running a series of articles with Excel Tips. There were some great tips in this week’s list, but my favourite one was down in the comments section – how...

VLOOKUP Sorting Problem http://blog.contextures.com/ 9

Excel VLOOKUP Sorting Problem

You can use an Excel formula to pull data from a lookup table – for example, enter a product name, and automatically see its price. Be careful though, or things can go horribly wrong,...

Create a 12 Month Rolling Total http://blog.contextures.com/ 0

Create a Rolling Total in Excel

It’s easy to create a running total in Excel, and show the accumulated amount in each row. You can use the SUMIF function in a table, or show running totals in a pivot table....