Jul 27 2022 07:00 AM
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
Jul 27 2022 07:24 AM
Solution
Webinars:
=INDEX(SORT(Webinars!A9:D100,2,-1),SEQUENCE(3),SEQUENCE(,4))
Website:
=INDEX(SORT(Website!A9:D100,2,-1),SEQUENCE(3),SEQUENCE(,4))
Jul 28 2022 05:21 AM
Thanks so much,@Patrick2788! This was awesome!
Jul 28 2022 05:51 AM
Jul 27 2022 07:24 AM
Solution
Webinars:
=INDEX(SORT(Webinars!A9:D100,2,-1),SEQUENCE(3),SEQUENCE(,4))
Website:
=INDEX(SORT(Website!A9:D100,2,-1),SEQUENCE(3),SEQUENCE(,4))