This week's blog roundup brought to you by Excel MVPs Leila Gharani, Bill "Mr. Excel" Jelen, and Cristiano Galvão.
Excel Filter Trick Using Non-Adjacent Columns, Leila Gharani
Leila Gharani shows an interesting application of the FILTER function. With this method you can use the FILTER function to return match results from non-adjacent columns. The same trick can be applied to the UNIQUE function to get a unique list of values from non-adjacent columns.
Using SEQUENCE inside of other functions such as IPMT, Bill "Mr. Excel" Jelen
When you first see the dynamic array functions of SORT, FILTER, UNIQUE, SORTBY, RANDARRAY, the SEQUENCE function might seem like the most trivial. But the real power of SEQUENCE is when it is used as an argument in other functions to coerce them to return an array. In this article, Bill "Mr. Excel" Jelen shows how to calculate the total interest to book for an entire year.
Dynamic Folders in Excel Power Query (in Portuguese), by Cristiano Galvão
Excel MVP Cristiano Galvão describes step by step how to get data with Power Query from a lot of files inside folders that can be switched according to the user's needs and keeping the same query, in a dynamic way.
###
O MVP de Excel Cristiano Galvão descreve passo a passo como obter dados com o Power Query a partir de um monte de arquivos dentro de pastas que podem ser trocadas de acordo com as necessidades dos usuários e mantendo a mesma query, de um jeito dinâmico.
Click the Like button and/or leave a comment below