This post has been republished via RSS; it originally appeared at: Excel Blog articles.
How to Connect Excel Tables, Ajay Anand
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
Click the Like button and/or leave a comment below