Get the initial (middle name) from a triple name in a cell.
C4 The cell contains the triple name separated with spaces.=LEFT(C4,1) & "." & MID(C4, SEARCH(" ", C4, 1) + 1, 1) & "." & MID(C4, SEARCH(" ", C4, SEARCH(" ", C4, 1) + 1) + 1, 1) & "."
Category: Basic Math
Walking Columns
An easy way to scroll through set of data in a graphic way without graphs.
A-pure-formula xlsx workbook. These were done using formulas, conditional formatting, and ActiveX control.
Unix DateTime Number
Convert Date/time number from regular number to Unix DateTime Number.
Get 3rd Wednesday of month
This was an interesting request.
Needing to get the date of 3rd Wednesday for a given month, automatically, using pure Excel functions.
So, sharing here on what is the formula and how to get there.
Repeated Offset
I needed to have an offset of columns to be repeated every 12 months.
This is part of a project, we needed to calculate the coefficient of sales prediction based on the month number, we do have coefficient saved in another table that repeated every year (12 months).
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
0% interest promotion
The past few months, I established a formula to help me determine if certain credit card promotion makes sense or not.
This helped me a lot in consolidating my debts (credit card as well others) into interest-free payments. Benefiting from banks and cards promotions. The key part is to determine how much monthly I will commit to pay in order to keep it actually 0%.
So here is the formula.
Schedule column
Create list of dates excluding weekends and holidays.
Basically create list of workdays in a certain year, you may fill in to get more.
List of holidays is defined in another column, formula already excludes Saturdays and Sundays.
SimpleANBox
This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output.
During my time with technology (since 1997) I found myself needing to open a lot of these boxes, to track accounts, or loans, or virtual business partnerships between multiple partnerrs. And this is the core to it.
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 into next year and loop through its months again, and so on
Scorring, saving multiple outputs in 1 number
I have seen this practice before several locations
Returning multiple outputs in 1 single number.
for example