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...
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)
)