Walking Columns
An easy way to scroll through set of data in a graphic way without graphs. A-pure-formula xlsx workbook. These were done using formulas, conditional formatting,...
Repeated Offset
I needed to have an offset of columns to be repeated every 12 months. This is part of a project, we needed to calculate the...
0% interest promotion
The past few months, I established a formula to help me determine if certain credit card promotion makes sense or not. This helped me a...
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...
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...
Insert Blank rows into table using functions
Here you will see how to work with functions to insert a blank row every certain number of rows in a table using a blank...
Change Calculator – calculate change in multiple bills/coins
An Excel file that will determine what cash to return to the buyer (How much of each cash unit, or how many of Fifty dollars...