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 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...
Only the cell referenced but you can copy the formula down to the others rows.
- Thanks, I super appreciate your help... I think I'll try this way, and work on learning how to use the array formula this month...
