This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've attached the Excel output file from my workflow.
So, essentially what I want to do is to repeat the "Sum_Total_Empl" for every record so that I can make a calc that takes the Ext Hires (excl Sep) and divides it by the PREVIOUS YEAR End total. For example, in row 12 I want the calculation in cell H12 to be 48/3812 (or E12/D12)
I want the "Sum_Total Empl" numbers for the first 10 records to show in the next 10 records.+
So, I want the 2017 Year End numbers (Dec) to show in 2018, the 2018 show in 2019 and so forth - for every month I want the Prior Year DEC numbers to show. The DEC numbers are my baseline for the calculation for every single month for every single record