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