79708287

Date: 2025-07-20 18:47:37
Score: 0.5
Natty:
Report link

enter image description here i have solved most of the complex scenarios using FILTER Function here is the explanation which i have given step by step

(1.)First find the MAX-You will get the MAX number

(2.)now this MAX number at what position is present we will use SEARCH from that array.

(3.)This SEARCH will definitely give an error where it doesn't find this number from that array and a number(position) where it finds.

(4.)So obviously the FILTER function accepts Boolean data in the include argument,so we will turn this SEARCH into Boolean by ISNUMBER.

(5.)So this will convert into TRUE/FALSE.

(6.)now what we want to filter?

subjects right?

So Filter the subjects where there is TRUE

Reasons:
  • Blacklisted phrase (1): enter image description here
  • Whitelisted phrase (-2): i have solved
  • Long answer (-0.5):
  • No code block (0.5):
  • Contains question mark (0.5):
  • Low reputation (1):
Posted by: Aishwarya Borkar