Compile Property Features List
I have columns for 'Pool', 'Garage', and 'Garden' marked with 'Yes' and want to join the feature names into a description.
=TEXTJOIN(", ", TRUE, IF(B2="Yes", "Pool", ""), IF(C2="Yes", "Garage", ""), IF(D2="Yes", "Garden", "")) How it works: This TEXTJOIN formula efficiently combines property features into a single, readable string. The `", "` acts as the separator between features. `TRUE` for the second argument ensures that if a feature's IF statement returns an empty string (because the feature is 'No'), TEXTJOIN will ignore it, preventing extra delimiters. Each `IF(B2="Yes", "Pool", "")` statement checks if a specific feature column contains 'Yes'. If it does, the feature's name ('Pool', 'Garage', 'Garden') is included; otherwise, an empty string is returned. TEXTJOIN then intelligently concatenates only the non-empty feature names.
Data Setup
| Property ID | Pool | Garage | Garden |
|---|---|---|---|
| 101 | Yes | Yes | No |
| 102 | No | Yes | Yes |
| 103 | Yes | No | No |
| 104 | No | No | No |
Step-by-Step Guide
Organize your property data with distinct columns for each feature (e.g., 'Pool', 'Garage', 'Garden'), using 'Yes' or 'No' to indicate presence.
Select the cell where you want the combined property features description to appear (e.g., E2, if your data starts in row 2).
Enter the TEXTJOIN formula, specifying the delimiter (e.g., ", "), setting the 'ignore_empty' argument to TRUE, and using IF statements to conditionally include feature names based on the 'Yes' value in their respective columns.
Press Enter to apply the formula to the first property.
Drag the fill handle (the small square at the bottom-right of the selected cell) down to apply the formula to all other properties in your list.
Explore More
Match Property ID to Listing Price
I have a list of sold properties by ID and need to retrieve their original listing price from a master database.
Count Listings in Specific Zip Code
I want to count how many active property listings I have in the 90210 zip code area.
Total Sales Volume by Agent Name
I need to calculate the total value of all properties sold by a specific agent named 'Sarah' this quarter.
Calculate Monthly Payment for Client Budget
I need to show a client what their monthly payment would be for a $350,000 house at current rates.