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...
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....