## 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: COLUMN

##
Walking Columns

##
Repeated Offset

##
Get column name (columnname as A,B,C, etc) as input inside cell

##
iframe in Excel (XLiFrame)

##
Rotate table using 1 formula

##
Sort list dynamically (functions)

##
Insert Blank rows into table using functions

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

Excel already has the formula ROW() =Row() Which as we may already know will give us the number of the row we are in, if...

This is the iframe in Excel, if you are familiar with the HTML concept of iframe, you will understand this one right away, it is...

Rotating table (Transpose) using functions so that the table is updated once the source table is updated. Also can be used as automatically rotating tables...

Sorting a list automatically using formulas, with no need to press the sort command Also if the source table is changed, the destination table will...

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