Forum Discussion
Need help with creating a formula
I need help creating a formula that returns multiple values to one cell based on a column's value. Tactics Week Due Date Due Owner ECOM: Make list of 20 product ideas 2 6th Mar ...
The Concatenate function can be used to return multiple results in a single cell. What you don’t say is where the results are being picked up from. Example: cell A1 = Aiden, B1 = HEALTH, C1 formula = Concatenate(A1, “ - “, B1)
Result in C1 = Aiden - HEALTH
Hope this helps.
Result in C1 = Aiden - HEALTH
Hope this helps.
The results should come from the tactics column based on the week due... basically, place the tactic in the corresponding week based on the week due...
Question: Does the Concatenate function look at the entire column or just one cell in the column?
BTW, thanks for such a quick response...
