Description:
The new filter function in LibreOffice 24.8 is producing the wrong output that is desired from the data table.

Steps to Reproduce:
1. Enter the value "Name" into cell B2
2. Enter the value "Number into cell C2
3. Enter the name "Jerry" into Cells B3 and B4
4. Enter the names Sam, Larry and John into cells B5:B7
5. Enter numbers from 1-5 in cells C3:C7
6. Enter Data validation in the cell E2 for cell range B3:B7
7. Enter filter function formula in Cell F2; =filter(C3:C7,B3:B7=E2," ")
8. 

Actual Results:
When selecting the Names from the data validation the filter function is giving the correct numbers for every name found in the table however only for the name Jerry(since it appears twice in the table) is gives the first number that appearing in the table. When the formula is dragged down the reverse situation occurs, the correct numbers will be outputted for the name Jerry but for every other name in the data validation the function will output the same number twice instead of once.

Expected Results:
Giving the same output(as well as numbers of outputs) as the appearances in the data table.


Reproducible: Always


User Profile Reset: No

Additional Info:
In Microsoft Excel the filter function formula is able to automatically detect the number of appearances of inputs and outputs in the data table.