Convert cell into textbox
Often times, I found myself the need to design a sheet where I want users to input something, and I need them to focus on...
FORMULATEXT to show formulas
Back in the day, we used to need to write a full macro (also called User-Defined-Function) to allow users to show the formula from a...
IFS (and IFNA) to avoid nested IFs
I tend to see more and more the usage of nested IF functions recently Now, do not get me wrong, IF is great, but come...
Highlight dates dynamically
Conditional formatting is another powerful feature in Excel, especially when you combine it with functions A simple function as in below if you set it...
Excel ad from early 90s
Guess what I just found in my old archive !...
Limited Ceiling
The function CEILING (CEILING.Math as of Excel 2016) is a very good powerful function. It allows you to round number to any value up Unlike...
Count cells with condition – multiple conditions
We did see who we can get total of a column for a certain month in certain year using SUMIFS. SUMIFS got a sister function,...