Progress bar in pure functions
This one is very similar to Tally chart, however, it is for another purpose. It is used to draw a progress bar, yes a progress...
Excel Dynamic Drop-Downs that grow with you
This will help you do a dynamic name to use on a drop down, a Form Listbox or Form Combobox. The screenshot almost says it...
Tally chart in functions
Using a single function can make a graphical view to your number Function is REPT along with IF and INT to show that number in...
CamelCase to Camel Case
Here is a good practice for combining functions to get a full smartsheet It basically add a space before any capital letter in a text,...
Sum of divide – Array formula
This is the answer to an old question: Here is the story behind it: I had a client who calls me every now and then...
Standard math to calculate Aspect Ratio
Here is a simple formula that uses standard math functions (+ , – , / and *) to calculate the aspect ratio I often need...
MID + SEARCH to convert cell to rows
I have been there and done that more than once before This time I had a really large cell, more than 3k characters need to...