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 graphical view, formula used here …
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, helpful when you have strings …
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 asking the same question: ” …
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 some simple formula like this …
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 be converted into rows, and …
Hyperlink usage and HyperlinkOf UDF
The Hyperlink function is really powerful and yet not widely used. You can create a whole navigation system with Hyperlink fx or create a custom jump to link to take user …
Excel Functions = XL f(x)s
This is the website I have been waiting for a while to create. It should be simple and educational, Excel functions is the love of my life, been always love …