Forum Discussion

kittenmeants's avatar
kittenmeants
Brass Contributor
Sep 07, 2023

Index and Sort formula help

Hello!   I need help modifying this formula to accommodate the new year, 2024.    So this is what the table currently looks like(small version), and I am pulling this information to a separate ta...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Sep 07, 2023

    kittenmeants 

    How about

     

    =INDEX(SORT(B16:D130,3,-1,FALSE)SEQUENCE(10),{1,3})

HansVogelaar's avatar
HansVogelaar
MVP
Sep 07, 2023

kittenmeants 

How about

 

=INDEX(SORT(B16:D130,3,-1,FALSE)SEQUENCE(10),{1,3})

  • kittenmeants's avatar
    kittenmeants
    Brass Contributor
    Sep 07, 2023
    You're amazing.

    Thank you!!

Resources