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 on the month number, we do have coefficient saved in another table that repeated every year (12 months).
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.
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 is actually has the minimum (or maximum) of savings among other columns. Trick is as you guessed it was OFFSET.
Using formulas to repeat list, I call it LoopList Used to list Months for several years, in away that with 1 formula, it will loop through all months, then jumps into next year and loop through its months again, and so on
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 level of expertise in each
One of the power of combining functions in one cell is using the best of these functions An example is here, OFFSET + MATCH will allow you to do something similar to VLOOKUP. Why do we want to do that? VLOOKUP will search in the left-most column in a table to get a value from […]