Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Dec 24, 2022
Solved

Filtering Data

Hi I need to use the FILTER function to filter the range (C6:Q55) of the attached file to get the student name who got degree less the 50 in any defined subject (D4:Q4). The defined subjects should ...
excel
office 365
  • Lorenzo's avatar
    Lorenzo
    Dec 24, 2022

    Hi ajl_ahmed

    Does this function update dynamically? I mean that if I change the degree from <50 to >50 the elements will be changed? => Why don't you try???

     

    A sligthly more concise one:

    =FILTER(C6:C55,
  MMULT(--(D6:Q55 < 50),SEQUENCE(COLUMNS(D4:Q5)))
)

     

Lorenzo's avatar
Lorenzo
Silver Contributor
Jan 03, 2023

Hi ajl_ahmed 

If any of the option you've got solves this issue, would you be kind to mark it as solution to help those who search, please? Thanks

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jan 03, 2023

    Thank you SergeiBaklan. I wasn't necessarily expecting mine to be marked though

    I guess you understand my main concern

Resources