Is it ok to make one manual adjustment to an automation task to avoid the complexity of a fully automated task?
Aggregating Text
Post Category → Solutions
Sorted Data Validation List
This post from ExcelFORO explains how to use VBA to create a sorted data validation list. It’s a great solution! Are there other ways to solve this? Continue reading
Weighted Average
I’ll show you the weighted average formula, how it calculates, and I’ll prove that the answer is correct! Continue reading
Retrieve 1st Code for Selected City When Description is not blank
In Microsoft Excel there are often many different ways to create a solution. The best solution is often subjective based on whether we emphasize simplicity or efficiency. Here is a good example: Continue reading
Variable Sized Groups Within Each Column
Every once in a while we get a unique challenge in Excel. This one required some creativity to quickly create a solution due to a pending deadline.
Continue reading
Video 00174 Ranking Values into Tiers in Excel
Last year I started visiting some REDDIT Excel groups. A few weeks ago I saw an interesting Excel question and provided a simple two step solution. Continue reading
Video 00158 Keyword Data Validation List
Is your data validation list is so long that the endless scrolling makes you want to close Excel and never use it again? This post will review several solutions to this problem. Continue reading
Video 00171 Create Christmas Lights Using Excel Sheets
Did you know that an Excel UDF can change the color of a sheet tab? David Hager’s post shows us how to do this! Somehow I came up with the idea to create Christmas Lights using Excel sheet tabs! Continue reading
Video 00167 Sliding Formula Ranges
Data lands in Microsoft Excel in many different structures. Data Analysts like me will often tell you to normalize your data before starting your analysis. This post contains three examples in which normalizing your data might not be necessary when doing a quick analysis. Continue reading
Video 00166 Count Groups Above or Below Targets
This Excel puzzle almost sounds like it could be solved with a quick COUNTIFS function but it’s a bit more involved than that. Nevertheless, it doesn’t have to get complicated as it can still be solved using a few simple steps. Continue reading