WPS Spreadsheet FILTER function only show 1 result row

121 Views Asked by At

I try to use FILTER function, but only show 1 result row / cannot show all results Is there any configuration in WPS spreadsheet to show all result? Please help ^_^ Thanks

enter image description here

=FILTER(A1:A3,B1:B3=1,ZZ)
0

There are 0 best solutions below