Page 415 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

• Then, go to cell B20 and paste the following formula into that cell.

=FILTER(B5:E14,(C5:C14=B17)*(D5:D14=D17),””)
Here, B5:E14 represents the range of the array. C5:C14 serves as the Section column. B17 performs as the
section to be filtered. D5:D14 means the Subject column. Lastly, D17 acts as the subject to be filtered.

The FILTER function has three arguments. Here, B5:E14 is the array argument. And (C5:C14=B17)*(D5:D14=D17)
is the include argument. Basically, this works like a Boolean array; it carries the condition or criteria for filtering. In
this case, we’ve two criteria combined by a (*) sign.
• After that, tap ENTER.

Note: Filter function available in Excel 2021 and Above Versions.

400
CITS : IT & ITES - Computer Software Application - Exercise 68