Excel MVP Blog Roundup

Published Oct 09 2020 10:00 AM 3,112 Views

This week's blog roundup brought to you by Excel MVPs Leila Gharani, Bill "Mr. Excel" Jelen, and Cristiano Galvão.


Leila GharaniLeila GharaniBill "Mr. Excel" JelenBill "Mr. Excel" JelenCristiano GalvãoCristiano 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




Version history
Last update:
‎Oct 08 2020 02:04 PM
Updated by: