Description:
I have a list of people's names and sections in a scout group they belong to. I have a matrix/array FILTER function that is intended to return only those people within a selected section (e.g. 'Beavers' or 'Scouts').

If the filter finds only one (and only one) person in a section, the result returned will repeat that person down the entire array (397 rows, in my example). If the filter finds any other non-zero value, it only displays that many results - for example, 3 people found will return 3 rows.

Steps to Reproduce:
1. Create some dummy data - firstname,lastname,group
2. Ensure each group is used at least twice, except on one person
3. Create a matrix/array filter to return all those in a particular group
4. Change the search term to be the group that only has one person in it

Actual Results:
The single person is correctly identified, but their details are repeated multiple times (depending on how large the array is)

Expected Results:
Provided only one result - not one result repeated multiple times


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 25.8.1.1 (X86_64)
Build ID: 54047653041915e595ad4e45cccea684809c77b5
CPU threads: 18; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: CL threaded