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,...
Show developer tab
Starting Excel 2007, users are not getting easy access to developer stuff. Not sure why is that, but we can go around that, so quickly,...