Dynamically Fill a column with values from another column

[apatel1501]

I have the attached dataset with 3 years of sales and margin data.  However, my dataset will sometimes have 4 or 5 years or more. I'm able to dynamically calculate the Min_Period and the Max_Period from an earlier portion of the workflow. I want to fill the Min_Period with P01_Sales and Max_Period with P03_Sales. The problem is, the Max_Period may sometimes be P04_Sales or P05_Sales so a regular formula won't work.

Any ideas on how i can get Max_Period value to recognize the latest sales year and fill the cell with those values? For instance - Max_Period Row 1 should = P03_Sales Row 1.

Thanks!

[apatel1501]

Attaching the data in excel in case its helpful

[binuacs · Accepted solution]

@apatel1501 created a workflow based on my understanding

[apatel1501]

Thanks! That worked - appreciate it!