Archive for September, 2020

Ever wanted to create a two-level data validation list? You can use this simple trick to make two-level or cascading drop-down validation lists in Excel. You need some data, a pivot table and simple IF formulas to get this. Read on to understand the process and create your own two-level drop down lists in Excel.

Got some data in a calendar format and just wished you can get it in tabular format?

You can use Excel formulas or Power Query to do this. In this article, let’s review formula based approach with two excellent choices.