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 …
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 …
Looplist – Repeating months using formulas
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 …
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 allow you to do something …
MATCH fumction, just a simple search
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 …
State Abbr with Index+Match+Validation
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 …