Someone asked me how to make a data validation drop down that only shows the visible rows from a filtered list. I created a sample file that shows how you…

When you first start to use Excel, you probably work with files that somebody else set up. Eventually, you're ready to build a workbook of your own, and this video…

In a perfect world, nobody would ever make a mistake in Excel. Every formula would be flawless, and every bit of data would be valid. Unfortunately, that's not the case.…