## 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 …

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 …

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 …

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 …

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 …

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 …

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”, …