Here is the UDF to Convert Numbers to Words in Hindi Language. This can be extended for other Languages as well with little modifications, do let me know your thoughts in comments. How to create the function Called SpellNumber() 1) Start Microsoft Excel. 2) Press ALT+F11 to start the Visual Basic Editor. 3) On the […]
Articles Tagged: Learn Excel
Excel VBA: Different Types Of Excel Macros
Excel support services will receive scores of different questions each and every day. The range of the questions definitely covers a lot of ground. Among the most common of questions asked is “What are the different types of Excel Macros?” This is a helpful question to ask because if you do not know the different […]
Excel VBA Tip: Remove Blank Lines From A Text File with Condition
If you’ve ever worked with text files, you’ll know how frustrating it can be to remove empty lines. Part of the problem is that you don’t want to remove every blank line otherwise it might upset the formatting of the document. This article will show you how to remove a set number of blank lines […]
Excel Function: MATCH() Explained
Excel MATCH function examples allow us to see how the MATCH function can be used, and understand what scenarios it could help us. Basically, the MATCH function was designed to return a relative row reference (relative to the array in which data is searched for) for data that you specify. If searching for a number, […]
How to Automate MS Excel Using Visual Studio.NET
Introduction I have written this article to address requests I have been getting through e-mail on how to automate MS Excel. Most people who are looking at this article might also be interested at the following articles for automating MS Word documents. Here is the link for Automating MS Word using C#, and here is […]
VBA Tip: Filter An Excel Table On Multiple Columns
Filtering information out of a larger data set is standard Excel functionality but sometimes it’s necessary to fine tune the filtering to get the information you need. For example, you might have a list of customers prioritized as A,B or C. Additionally, you could have them listed by region. Something like this. Customer, Category, Country […]
Excel Formula Vs Function : What is the difference?
Once question I get asked about a LOT it when it comes to Excel is just what is the difference between a Function and a Formula? In this article I will discuss the differences and work through some examples. A Formula in Excel can be described as a statement that is written by a spreadsheet […]
Excel Tip : How to Generate Unique Usernames using the IF() and COUNTIF() Functions
Today let’s learn how to generate unique usernames in Excel, even when you have duplicates in your data. Formulas Used 1) IF( condition, [value_if_true], [value_if_false] ) Learn More about IF() Parameters or Arguments condition The value that you want to test. value_if_true Optional. It is the value that is returned if condition evaluates to TRUE. […]
How to Flag Multiple Matches In Your VLOOKUP Formula?
This article will explore the Excel VLOOKUP Formula and show you how to combine it with an IF statement to flag if there are multiple lookup values matches in your data set. VLOOKUP is really great for pulling in data from a larger table in Excel, but sometimes in a larger data sets there may […]
Excel Formula : SUMPRODUCT () for Advanced Users
When I first learned about the SUMPRODUCT formula in Excel , I almost dismissed it as a useless formula used by only few users. How often would anyone need to multiply 2 or more groups of numbers together and add up the results!? To get to the story, we know that formula is keyed in as: […]