0

enter image description here

Hello, I need help extracting information if the criteria are matched. So I need to extract a list for (level) MAG4 if a student received fewer than 8 points or get below 80%, and I need to extract a list for (level) MGT4 if a student received fewer than 25 points or get below 80%. I would like to have one formula that will solve this problem. Any help will be very appreciated!

Improve this question
2
  • Publish some test (example) data safe for experiments (public GoogleTable is safe, for example).
    – Akina
    Commented Sep 3, 2019 at 5:57
  • I think you need to provide a sample
    – Bella
    Commented Sep 3, 2019 at 9:14

1 Answer 1

Reset to default
0

This array (CSE) formula solves the issue:

enter image description here

  • Formula in Cell F31, finish with Ctrl+Shift+Enter & fill down.

    {=INDEX($A$31:$A$49, MATCH(0, IF(OR($G31<$B$31:$B$49, $H31<$C$31:$C$49),COUNTIF($F$30:$F30, $A$31:$A$49), ""), 0))}

Adjust cell references in the formula as needed.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .