Category: Excel Formulas

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/ 15

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

Hide Formula Results Based on Date http://blog.contextures.com/ 5

Hide Formula Results Based on Date

My challenge this week was to show the running total in a list, but only for the current date and earlier. I wanted rows for future dates to appear empty, but have the formulas...