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.
Lookup and references functions, comes with Excel
Get 3rd Wednesday of month
This was an interesting request. Needing to get the date of 3rd Wednesday for a given month, automatically, using pure Excel functions. So, sharing here on what is the formula …
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 coefficient of sales prediction based …
Sorting with functions only
This one is similar to http://xlfxs.com/sort-list-using-functions/ where we use some controls here that make it more user-friendly.
Searching table in 2 dimensions.
Using VLOOKUP + MATCH (HLOOKUP + MATCH, OFFSET + 2 MATCHes or INDEX + 2 MATCHes) to search a table in both axis. This post has been sitting for a …
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 archive.
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 which of the 4 columns …