Cuts string of list of items
An old lesson to one of my early classes to show how can we cut a string having list of items into its parts. (At...
Excel @ before function names in formulas
Looks like there is a change coming. Excel started adding the symbol @ to some formulas, not sure why only those, but we are waiting...
Return 12 values in one number
A technic I loved using, return list of items (up to 12 items now) in ONE number. Let us say you have list of 12...
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...
Always get 1st name (or last)
Formula to get first name from 2 formats either (Lastname, First) or (Firstname Last) formats....
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...