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 ROUND, ROUNDUP and ROUNDDOWN, that …
Category: Math and Trig
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, COUNTIFS Which will count how …
Get monthly total from table with dates
Again, thanks to one of my students, I am getting another post with example 🙂 I did promise her to post it after she sounded interesting in getting this example …
Calculate hours between two cells
We needed that several times in the past Then I found it in an old file in my laptop, thought to share it for others to help So, when A1 …
Fx to cut long column into two columns
Convert one long column into two This set of formulas will get the items after row 45 (for example) from column A into the column B starting from B1 to …
Multiple Dual-Validations
It is to demonstrate how to do multiple validations in the same sheet, or as we want to call it Mutliple-dual-validations that depend on each other. Checking out sheet “Data”, …
Dynamic selection list
Using Index and CountA Formulas, Names and Forms > ListBox to have a list with connected formulas Can also be used as form to read from a large table in …
Validation based on another Validation
Creating a Data Validation based on another Data Validation Meaning that when you select from a drop down from the first the second will be filled with the list that …