This podcast can be found in iTunes by searching for “Business Intelligence Podcast” in this 22 minute show we cover: How to better present your purpose by switching the order, how OLAP can unclutter your job, and how we saved someone’s life by figuring out how to count colored rows in Excel.
If you’ve had a spreadsheet with many rows colored and other rows left uncolored, then you realize that there is no easy button to sort or count rows that have color. This can be a very time consuming process, unless you use Visual Basic. Here’s one solution that we’ve come up with.