The TRIMRANGE function allows you to remove blank rows or columns before, after, and before and after a set of values within a specified range of cells. It makes it easier to work with cells that are not empty, but recently there is a much simpler syntax for clearing a given range, which is by specifying a dot before the “:” symbol that separates the beginning and end of the range.
When you search a range of data, for example, by using the VLOOKUP function, the search is always performed by using a unique criterion. How to perform multiple searches or quickly change criteria? In the following text, you will learn about the DGET function, which allows for greater flexibility and easier finding of the required values in a given range.
The TRIM function removes extra blank characters, we all know this by now, and TRIMRANGE, as its name suggests, is used to remove empty values from a selected range of data. In addition, it is possible to specify whether their removal takes place in rows or columns and in which order. It is well combined with the SORT and UNIQUE functions, and in the following text you will see how to apply it in practice.
Translation in Excel documents is not a new feature, and with the advent of artificial intelligence, it works incomparably better than before and can be said to be competitive with the Google Translate service. Recently, we also got a TRANSLATE function that translates text from one language to another, and allows you to create reports that are dynamically translated.
Pivot tables have been with us for a long time and allow us to easily analyze data by changing the perspective from which we look at them. Recently, there is also a PIVOTBY function that allows us to get a similar report, but in an Excel spreadsheet. By marking rows, columns, values and other parameters, a dynamic report is generated. Here’s a post about how to use this function…