This week's blog roundup brought to you by Excel MVPs Ajay Anand, Mourad Louha, and Ismael Romero.
Ajay AnandMourad LouhaIsmael 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.