Forum Discussion
multiple tables
I am in the process of researching and finding a suitable university for me. I have created seven different tables from 2017-2023; each table contains information about the top 10 UK universities for the relevant year.
My question is, how can I make a new table that pulls the names of universities from the previous tables and get a new table with the top 10 between 2017-2023?
Thank you for your help!
1 Reply
Assuming 2 Tables like:
and you run the most recent version of 365 (Please read Welcome to your Excel discussion space!)
=LET( stacked, VSTACK(Table1,Table2), sorted, SORT(stacked, 2, -1), TAKE(sorted, 10) )
