Month: January 2012

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...

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...