Forum Discussion
Need help returning multiple values to one cell based on a two criteria
I have multiple properties and at each property there are multiple tenants. I am trying to show all the tenants that have that date to show up in the one cell. With this formula I can only get one te...
The FILTER function is what you need, and because it yields what's called a dynamic array, you need to put the different properties side by side, rather than vertically. I've attached one sample of how that could look. If you change the dates or property numbers in the orange background cells, the results will change to reflect your criteria.
The table on Sheet2 is a dynamic table, so you could add rows and see that the filter function on Sheet1 keeps up with you.
Here too is a good resource for learning about the FILTER function. (Oh, you will need a current version of Excel)