Forum Discussion
Patrick2788
Apr 30, 2022Silver Contributor
Formulas Challenge for 365
Thank you for reading this post! I propose a formulas challenge (The shorter the better). Attached is a workbook in need of two formulas. I have solutions for each (Formula 1 is 66 characters, ...
PeterBartholomew1
May 01, 2022Silver Contributor
I have attempted part 1 of your challenge but not within the rules. I only use defined names to reference data (at one time I ran macros to delete the content of any cell that contained a direct reference1).
My approach was to create an array of Thunks, each element containing the data from one of the tables.
Since submitting, I have had a look at Riny_van_Eekelen 's solution and may have some reconsidering to do. I had not realised that VSTACK works over a 3D range reference! It does mean that the tables have to be aligned but often they are.