UDF – Convert Number into text (English and Arabic)
Convert Numbers into English text and the final version of the Excel function to convert numeric values to Arabic text, (as 500 to خمسمائة). It will also enables you to …
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 bar in pure functions, using …
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 all. You need 4 steps: …
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 …