This article is contributed. See the original author and article here.
This week’s blog roundup brought to you by Excel MVPs Ajay Anand, Mourad Louha, and Ismael 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
Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.
Recent Comments