CODEWITHSUNDEEP
google-sheets
michaeldon
michaeldon

Reputation: 507

Filter function creates empty rows

My understanding of the google sheets filter function is that it should limit the results to an array where the conditions are satisfied but I noticed this oddity:

enter image description here

Here is the sheet: https://docs.google.com/spreadsheets/d/1RL9cE6CYcpdNdkoKJvZc_KJ53d8QrNoMEQe-kH-4lo8/edit?usp=sharing

formula for result 1: =filter(A2:A,A2:A<=105)

formula for result 2 =filter("x"&A2:A,A2:A<=105)

Question: Why does the 'x' continue down in rows where the condition is not satisfied?

Upvotes: 0

Views: 881

Answers (1)

Harun24hr
Harun24hr

Reputation: 36870

Because empty cells treated as zero 0. You can add an addition condition to FILTER() function to filter values greater than zero 0.

=FILTER("x"&A2:A,A2:A<=105,A2:A>0)

enter image description here

Upvotes: 1

Related Questions