SOLVED

Struggling to Populate Master Sheet With Most Recent Rows From Other Sheets

New Contributor

Hello,

 

I'm sure this is basic stuff, but I'm trying to create an Excel document that captures the three most recent updates (in a master excel sheet) from each project (populated in additional sheets). I'm providing a link to a stripped-down version of the document I'm trying to work with and would be grateful if anyone can offer their assistance or support.

 

Thanks in advance,

 

Brian

3 Replies
best response confirmed by btgtimmerman (New Contributor)
Solution

@btgtimmerman 

 

Webinars:

=INDEX(SORT(Webinars!A9:D100,2,-1),SEQUENCE(3),SEQUENCE(,4))

Website:

=INDEX(SORT(Website!A9:D100,2,-1),SEQUENCE(3),SEQUENCE(,4))

 

You're welcome! Glad it worked.