Today I Learned . . .
The FILTER function (in Google Sheets) can be used to condition a group of data into a new set with values of a certain condition (like blank cells) excluded (or included) in the new set.
FILTER(A2:B26, A2:A26 > 5, D2:D26 < 10)
No comments:
Post a Comment