When you enter decimal numbers, depending on the Region settings, you will use a decimal point or a comma. In most cases, this is done once, and we don’t deal with this topic anymore. However, it may happen in practice that you import data, most often from a CSS file, where different characters are used to separate decimals and groups than those you use by your local settings. In this case, use the NUMBERVALUE function…
Excel has recently made it easier to work with formulas that use arrays and constants – you no longer have to save them by pressing CTRL+SHIFT+ENTER! We can now use lists of values, given in curly brackets, as function arguments. This is great news, and the possibilities are manifold. In the following post, you will be able to see the real application of this feature…
The address of a cell in Excel is formed by combining the column label and the row number. For example, the address A1 indicates that it is a cell that is in the first row of column A. However, we can also assign an address in another way- by using the row number label and the column number. Thus, cell A1, in this alternative notation, would have the address R1C1. How to change the way the address is assigned and can it be of practical use?
It is common knowledge that the VLOOKUP function cannot return results that are “to the left” of a given range, and this problem is solved by XLOOKUP, which additionally allows you to search the range from the beginning or from the end. However, what if these functions need to return more results? To do this, you used to need to use array formulas, but today this is performed in a much easier way…
When we create a column chart to visualize data, the columns are often of different heights. We evaluate where the best sales were achieved visually or add data labels and then make the conclusion based on the appropriate numbers. Excel does not yet have conditional formatting for charts, but there’s a trick you can use to automatically determine the highest value in a series.