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....
6174 Kaprekar’s constant
This is the spreadsheet to prove this constant. When all roads lead to Kaprekar Just enter any 4 digits number in D3 and watch roads...
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...
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...
Cells with additional spaces
Detect which cells has additional spaces added by mistake by user. =IF(AND(Left(F2, 2) = "No", LEN(F2) >2, "Space at end", "")...
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....