easy5 pts · first answer countsexceldynamic-arrays

Listing only one region's rows

In Microsoft 365, data is in A2:D500 and regions are in column B. Which formula lists every row where the region is "South"?

A.=FILTER(B2:B500,"South",A2:D500)B.=FILTER("South",A2:D500)C.=FILTER(A2:D500,B2:B500="South")D.=VLOOKUP("South",A2:D500,4,FALSE)

Discussion 0

Join free to post in the discussion.