Notifications
Clear all
Topic starter
Hello,
In the attached file "Sheet 6", I am trying to use FILTER function for 3 criteria.
In Cell M12, if I used only 2 criteria, the result is OK.
In Cell M17, if I used 3 criteria, the result is "Not Found".
I don't know what issue is in here.
Posted : 17/01/2023 1:05 am
The file didn't come through. Please try again and don't forget to press the "start upload" button before you submit your reply.
Posted : 17/01/2023 4:27 am
Topic starter
Please see file attached.
Posted : 17/01/2023 5:48 am
The entries in your Type column have a trailing space, so you need "Single Family " as the criterion, or use TRIM on the range.
Posted : 17/01/2023 7:46 am
Topic starter
My fault.
Posted : 17/01/2023 8:40 am
