VLOOKUP Week: Who Needs VLOOKUP Anymore?
A couple of years ago at lunch, Bill remarked to me that VLOOKUP was the “scariest” feature in Excel
Month: March 2012
Poll Results
Even though it is still open, the one-question poll results have stabilized. In fact, the percentages were pretty stable even from the beginning.
The 3rd Most Common Button in Data Apps is…
A little bit of food for thought today, delivered in a pictorial/humorous style but with a serious point. A Running Joke That Never Gets Old I’m quite fond of the […]
Moore’s Law and Inflation
SQL Rockstar, aka Tom LaRock (Blog | Twitter) sent me a fascinating data set the other day: a table of different computing devices over the years, their “horsepower” in calculations per second
DAX – The Correct Usage of EARLIER()
Tonight I was looking at one of my recent posts, the one about “fuzzy” time relationships in calculated columns, and I discovered that I had used the EARLIER() function in places that I did not need to.
Auto-Modify Every Pivot in a Workbook
It’s been awhile since I’ve talked about Macros (also known as VBA). I think it’s overdue. Macros are nothing short of amazing. We couldn’t live without them at Pivotstream
DAX – Subtotals and Grand Totals That Add Up “Correctly”
Busy week here at the MVP Summit in Redmond. As usual, I can’t tell you anything I have learned this week – it’s strictly under NDA.