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 Ajay Anand, Mourad Louha, and Ismael Romero.

 

Ajay AnandAjay AnandMourad LouhaMourad LouhaIsmael RomeroIsmael Romero

 

How to Connect Excel Tables, Ajay Anand

Ajay shows how to build relationships between tables using Data Model in Excel.

 

Zwei Bereiche per Formel zusammenführen (Merge two areas using formula), Mourad Louha

Mourad describes how you can dynamically append two ranges by using a single formula and dynamic arrays, building the formula step by step and using the LET function make it more readable and more performant.

 

Power Query: Combinaciones sin repetición (Power Query: Combinations without repetition), Ismael Romero

Ismael deep dives in creating a list of combinations without repetition using Power Query and M language.

 

 

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.