Forum Discussion

alysia5's avatar
alysia5
Copper Contributor
Jan 30, 2020

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 DueDate DueOwner 
ECOM: Make list of 20 product ideas26th Mar = AidanECOM: Make list of 20 product ideas = Aidan
ECOM: Order samples for 4 best ideas313th Mar = SteveECOM: Order samples for 4 best ideas = Steve

 

I would like to take the all Tactics and place in the corresponding week based on the week due.

WK 1
2 - 8 Feb
HEALTH: Join gym = Aidan
HEALTH: Determine calorie intake
HEALTH: Buy running shoes = Aidan
KINDLE: Research and choose 4 topics = Aidan
KINDLE: Create book outline for book 1 = Aidan

 

Formulas and Functions

7 Replies

  • Charla74's avatar
    Charla74
    Iron Contributor
    Jan 30, 2020
    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.
    • alysia5's avatar
      alysia5
      Copper Contributor
      Jan 30, 2020

      Charla74 

      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...

      • Charla74's avatar
        Charla74
        Iron Contributor
        Jan 31, 2020
        Only the cell referenced but you can copy the formula down to the others rows.

Resources