GoLast to jump to last cell in a column
This dynamic Hyperlink cell with 1 complete formula will let you Go to first available cell in a column. To allow you to enter next row data.It can help you …
SimpleANBox
This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output. During my time with technology (since 1997) I …
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 …
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 …