I needed few months back to make a fixed-length ID iut if none-fixed-length numbers.
SO I used the function REPT with RIGHT to force all numbers to be converted into fixed-length ID (mainly having leading zeros)
And here is the formula
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
Expenses calendar, FaCal
Expenses calendar, to show when in a month you need to pay what bill An easy formula-only smart sheet to allow you get hold on your bills Refreshes every time you open, to show current month and shows bills Download FaCal Excel Online
Custom fiscal year calendar (CFlex)
Fully customized Yearly Calendar to show certain dates with certain format using conditional formatting, like mark 8th business day each month with certain color, 1st workday after 15th of each month, etc.
See the sheet “Data” for details and table of specific dates and rules. Contact me for more detail
Compare2, a tool to compare two sheets using formulas
Tool will compare between two sheets using formula/functions method. Once you type in full folder locations (for both files), file names and sheets names in file1 and file2. Make sure these two files are open, then sheet will be updated with comparison results, showing that every cell is checking for its equivalent addresses from both…
Read More “Compare2, a tool to compare two sheets using formulas” »
Edit directly in cell
One of the settings that I always change when I first get a new Excel installation is …
Remove “Edit directly in cell”
Here is where you find that option
BMI Calculator
A simple calculator, how come we do not have one like this?
Skills Grid
A small Excel file to show how we can create a chart-like Excel sheet
Used in my Resume to show different skill sets and the level of expertise in each
Sheet() and Sheets()
Getting total number of sheets (Sheets), or ID of this sheet (Sheet). The two new formulas Sheet() and Sheets() can do well, yes not perfect, we still need to have function to list sheet names, but it is a start