Saturday, October 16, 2021
This Excel map relies on conditional formatting to highlight areas of interest.

How to Set Up a Square-Format U.S. Map in Excel

For several years, the Wall Street Journal has occasionally used a square-format US map like the following image. But when I noticed a recent...

How to Set Up Multiple Conditional Formats with Formulas

In How to Set Up a Square-Format U.S. Map in Excel, I showed how to create a square-format US map in Excel. I also...

Latest Articles

To reduce errors in reports, you should foot and cross-foot them. But Excel's floating-point arithmetic gets in the way. Here's how to fix the problem with a standard deviation calculation.

How to Foot and Cross-Foot Excel Reports in a Floating-Point World

At first glance, the following report is an ordinary one. It merely sums an Excel Table by Product and Region, and then foots and...

Excel’s XLOOKUP Function Explained

Excel's XLOOKUP function searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't...

Excel’s VLOOKUP Function Explained

Excel's VLOOKUP function looks in the first column of an array and moves across the row to return the value of a cell. VLOOKUP is...
Advertisement
Advertisement