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...
jmw24 The final piece you're looking for is the TextJoin which, when combined with the filter function already mentioned, will return multiple values in a single cell as shown.
=IFERROR(TEXTJOIN(" / ",,FILTER(Table3[Tenant],(Table3[Property]=$A2)*(Table3[Date]=B$1))),"")
This and formula requires office 365 in order to work properly.
Hope this helps.
Dexter