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 walk you 6174
Pixel Excel Drawing
This guy has nothing to stop him
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 least 1st three parts) using formulas only.
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 to start using this new feature.
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 items, and you want a function that will return some of that list (with no order), then this is how you can do it. This has been sitting around for awhile in my archive. I called it 12Return4095
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", "")
Comments versus Notes
It is official and looks better now, I know it might be confusing, but I liked it so far
Excel now has “Comments”, the classic Comments are now called “Notes”
I used Notes a lot, mainly to remind me of certain expectations of some cells, or guide the user to some additional info about some cells, so got confused when I tried to insert Comment into cell.
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 while in my archive, waiting for me to get some time to polish and 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 archive.