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

     

Patrick2788's avatar
Patrick2788
Silver Contributor
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))

 

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Jul 28, 2022
    You're welcome! Glad it worked.