When Excel functions are not enough
BoldCodes is here to help.I actually doubt it, I mean the fact that you cannot do most of your daily activities in Excel using functions.Especially when you learn 20% of …
CHOOSE, a tree of decisions
If you are like me, then you must have needed to use CHOOSE function. This is basically like “SELECT CASE” statement, but more limited Back in the old days, we …
Count Unique
A question by a colleague on how to count number of unique items in a column made me realize, I don’t have that here.
So here it is …
Cell formats 0.0\% and 0.0%;(0.0%)
We needed a way to force Excel to show the % next to a number without dividing it by 100 You know, when you format a cell in Excel, to …
When Excel tells you to go get some life
This is what happens when you spend too much time in Excel Go have a break and get some life
DayName
Simplest way to get name of day as cell output from a date. Because you can custom format a cell with date to show only that day name This is …