Category: OFFSET

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

Search across sheets in function

Just when you need to search for a thing across sheets in a workbook. I am bored, so I am adding articles from my old...

Min Max vehicle

Finding which vehicle with minimum (or maximum) amount of savings among peers. This is an old request, found its formula in my archive to calculate...

Skills Grid

A small Excel file to show how we can create a chart-like Excel sheet Used in my Resume to show different skill sets and the...

OFFSET+MATCH

One of the power of combining functions in one cell is using the best of these functions An example is here, OFFSET + MATCH will...