Notifications
Clear all
Excel Expert
2
Posts
2
Users
0
Reactions
838
Views
Topic starter
I am trying to build up some background data for my spreadsheet, and I am trying to filter data from my table using multiple criteria.
For example,
I want to filter information where "Australia" and "Project Agreement" are selected. Should I use filter or Xlookup?
Kind Regards,
Fernanda
Posted : 18/10/2021 9:52 pm
Hi Fernanda,
If you want the result to be a filtered list then you should use the FILTER function.
Mynda
Posted : 19/10/2021 1:51 am