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.
This one is similar to http://xlfxs.com/sort-list-using-functions/ where we use some controls here that make it more user-friendly.
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 …
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 …
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 …
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 …
To do a search in a column or a row, MATCH is the function to look for It is very simple, you set the value to look for and where …
Small file that will show how to do INDEX + MATCH formulas to get the abbreviation of the state based on its name or the name of the state based …