Category: Excel Formulas

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

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

Count Items Based on Another Column http://blog.contextures.com/ 8

Count Items Based on Another Column

How can you count items in one column, based on a criterion in a different column? We’ve shipped orders to the East region, and want to know how many orders had problems (a problem...