Idea If you have an excel file and there are a lot of overlapping shapes, not beautiful, what will you do. As for me, I will think of some way…

Idea This article I will share about a very useful Add in. That’s caclulator in Ms Word. There may be similar Add in but it will be unique. The idea…

Idea When making an excel report, you will probably see cells containing the formula. In it, this cell value is equal to the other cell. You can see the following…

## NUMBER FORMAT TRICK WITH THOUSANDS, MILLIONS AND BILLIONS WHEN USE COMMAS TO SEPARATE THOUSANDS

Idea As someone who knows a bit about excel, I often receives some rather specific requests. There was a request from a friend about the issue of formatting numbers in…

Idea In fact, when making a report you may have trouble with very long data units. If you want to short it into a billion-dollar unit, you have to divide…

Ideas If you have learned about Excel, you will realize that Excel has a huge disadvantage. Specifically Excel 2010 is limited to 1.048.576 rows and 16.384 columns. So to solve…

If you need to split the string separated by delimiters as commas, colon, slash, dash or other delimiter quickly, let’s read the following article. First, I will take a example…

## EXTRACT UNIQUE ITEMS FROM A LIST USING INDEX, MATCH AND COUNTIF

Syntax Extracting unique items from a list using 3 main functions are INDEX, MATCH and COUNTIF. In the example here, the formula in cell B2 is: =IFERROR(INDEX(Data, MATCH(0, INDEX(COUNTIF(Unique, Data),0),0)),””)…

In VBA, there are many interesting functions with its specific functions. In this article, I will share about DIR function and some of its applications in practice. Dir function Returns…

So what is VBA attractive? VBA or Visual Basic Application is a programming language in excel. Understandably, you can write the command line to do what you want in excel.…

- 1
- 2