New answers tagged filter
0
votes
Accepted
Filter from specified columns and display results into 1 column
Use { array expressions } to stack the data, like this:
=filter( { Data1!C4:C; Data2!C4:C }, { len(Data1!E4:E); len(Data2!E4:E) } )
Top 50 recent answers are included
Related Tags
filter × 84google-sheets × 75
formulas × 55
google-sheets-query × 29
google-sheets-arrayformula × 19
regex × 6
importrange × 5
gmail × 4
regexextract × 4
vlookup × 3
google-sheets-filter × 3
gmail-filters × 2
conditional-formatting × 2
email × 2
gmail-labels × 2
keyboard-shortcuts × 2
sorting × 2
gmail-search × 2
outlook × 2
data-validation × 2
json × 2
github × 1
search × 1
google-sheets-dates × 1
office-365 × 1