## 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,...

Skip to content
##
XLf(x)s

#
Category: INT

##
Walking Columns

##
Repeated Offset

##
0% interest promotion

##
Limited Ceiling

##
Fx to cut long column into two columns

##
Insert Blank rows into table using functions

##
Change Calculator – calculate change in multiple bills/coins

Excel functions and formulas

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,...

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...

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...

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...

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...

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...

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...