SOLVED

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

Copper 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 (Copper 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.
1 best response

Accepted Solutions
best response confirmed by btgtimmerman (Copper 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))

 

View solution in original post