Tag Archives: Visual Basic

OLAP – The Business Intelligence Podcast [BIP]

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

Posted in Best Practices, Excel, Podcast, Presentations, Purpose | Tagged , , , , , , , , , , , | Leave a comment

How to Count or Sort Rows by Color

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

Posted in Best Practices, Excel, Video | Tagged , , , , | 2 Comments