Excel MVP Blog Roundup

This post has been republished via RSS; it originally appeared at: Excel Blog articles.

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

 

 

 

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.