search

goosepirate / lox365

⚗️ Lox365: XLOOKUP for LibreOffice
GNU General Public License v3.0
82 stars 5 forks source link

filter with dynamic filter value returns unexpected results #9

Closed spi43984 closed 10 months ago

spi43984 commented 1 year ago

I'm trying to use a value in a cell D1 as filtering value.

image

The image above shows the result for value 4. the next ones show the result for 3, 2 and 1.

image image image

What is the correct approach to filter a list by a value that might change?

BTW - if I expand the list A2:B4 to something bigger the FILTERed list doesn't expand - I need to delete and create it from scratch.

goosepirate commented 11 months ago

Thanks for raising this issue. Try the latest version of Lox365. It should no longer repeat when the result is a single row. As for expanding the output array, I don't think there is a way for an extension to do this, but you can make it large from the start.