79332467

Date: 2025-01-06 08:19:55
Score: 2
Natty:
Report link

=FILTER(INDEX(array,SEQUENCE(ROWS(array)),{1,2,4}),referance Column = required field)

Index: you can select your disere column from your array. like 1,2,4. if not required 3 so skip

Sequence+Rows: it will reffer your data till end (all rows of your array)

Include: here you can give your referance column from where you want to filter and witch word or field you are looking.

Reasons:
  • No code block (0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Muhammad Nadeem