Forum Discussion

btgtimmerman's avatar
btgtimmerman
Copper Contributor
Jul 27, 2022
Solved

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

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

excel
  • Patrick2788's avatar
    Patrick2788
    Jul 27, 2022

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

     

Resources