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, and ActiveX control.
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, and ActiveX control.
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 coefficient of sales prediction based …
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 lot in consolidating my debts …
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 …
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 …
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 sheet to copy all values …
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 and how many of Twenty …