Everybody knows that you can do amazing things with Excel, but who would imagine a function like BAHTTEXT? According to Microsoft, this function “Converts a number to Thai text and adds a suffix of Baht.” There are no functions that convert numbers to text in any other language, so why Microsoft chose to develop this function remains a mystery. I’m guessing that one of the developers did it to impress someone who speaks Thai…
Sadly, I don’t speak a word of Thai, so in order to determine whether or not the BAHTTEXT function is good enough to impress anyone, I checked the results in Google Translate. This is what I got:
How can you remove duplicates from a list in Excel?
Easy! Excel has a built-in feature for this. Just select one of the cells in the list and click on Remove Duplicates on the Data ribbon.
Voilà, the duplicates are gone:
For more advanced ways to handle duplicates (and triplicates, quadruplicates etc.), take a look at this article: How to Find Duplicates and Triplicates in Excel
More Easy Tricks:
Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.
In Word you can easily count the words simply by clicking “Word Count” from the Review ribbon. But what if you have your text in Excel? There is no built-in word count function in Excel, so we have to find another way.
In a previous post I showed how to count characters in a text string using the LEN function. We will use the same function, with a twist, to do a word count.
In many situations you collect data every day (sales figures, stock prices etc.) for weeks, months and years, while all you want to show in the chart is the last week or two. I’ve seen many people spending a lot of time updating the chart manually every day, so here I will show you how you can make a dynamic chart that always shows the last 7 days. Of course, you can use the same technique for any number of days, weeks or months.
What is the extra S in the function name?
The old functions SUMIF and COUNTIF let you add or count a range of numbers based on one criterion. For example, you could count all the members who have paid the annual fee in the table below. With SUMIFS and COUNTIFS you can have multiple criteria, e.g. count all the members who have a Silver membership and who have paid the annual fee.
How to use a wildcard
In the example below I have used the COUNTIFS function to count the number of members who fulfill the two criteria. But if you also want to be able to apply only one criterion without changing the setup, you can use a wildcard. Here’s how I’ve done it:
If you want to create a new worksheet in an Excel workbook, you can use the mouse and click next to the rightmost existing sheet. But why not use a shortcut instead?
Alt + Shift + F1
Download “Standard Keyboard” in Excel