# Category: Excel Formulas

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

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

## Keeping Track of Garbage in Excel

I’ve worked with “garbage” data many times in Excel. You know what I mean – data that is so messy it takes you hours (or days) to clean it up. This week though, I...

## Excel Lookup With Two Criteria

If you need to get a product price in Excel, you can use VLOOKUP or INDEX/MATCH to get the price from a lookup table, based on a product code. But what if you have...

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

## Choose From a List to Change Excel Data

Do you need a quick way to show different data in a worksheet? For example, on an order form, you could let people select a region, and automatically include the shipping cost or tax...

## Excel Sheet Selector With No Macros

If you’re setting up a workbook for other people to use, they’ll appreciate it if you make it easy to move around in the file. You can create a table of contents on the...

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

## Customize Weekends With Excel WORKDAY Function

If you’re trying to figure out when a project will be completed, you can use the WORKDAY.INTL function (Excel 2010 or later). It’s more flexible than the older WORKDAY function – it doesn’t assume...

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