Category: Excel Formulas

Split Address With Formulas in Excel http://blog.contextures.com/ 0

Split Address With Excel Formulas

If a cell contains a full address, what formulas would you use to show the street address, city, state and zip code in separate cells? That was the challenge that I gave to my...

7 Ways to Round in Excel http://blog.contextures.com/ 6

7 Ways to Round in Excel

It’s not usually as obvious as the error in the screen shot below, but have you ever seen Excel adding things up incorrectly? No wonder some people take out a calculator, to check the...

SUMIFS with empty criteria 5

SUMIFS Formula With Empty Criteria Cells

I recently learned about The 100-Day Project (#The100DayProject), in which you work on making something every day, for 100 days. Would Excel formulas (#100DaysOfXL) be considered an artistic project? Maybe not, but I had...

Excel Name Fix Challenge http://blog.contextures.com/ 8

Take the Excel Name Fix Challenge

Last week, in my Contextures Newsletter, I posted an Excel Name Fix challenge. There was a short list of names, which needed to be fixed. Then we needed to count how many were fixed....

Excel Rank IF Formula http://blog.contextures.com/ 1

Excel RANK IF Formula Example

Excel has a RANK function, so you can calculate where each number stands in a list of numbers. There isn’t a RANKIF function though, if you need to rank based on criteria. Someone asked...

Excel VLOOKUP Problem Numbers 0

Excel VLOOKUP Problem Numbers

Recently, someone asked me for help with VLOOKUP problem numbers: He had a list of 8-digit numbers. In the next column, there was a formula to get the first 3 numbers: =LEFT(A2,3) Based on...

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

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