hello
not sure if this is possible, but i have a list of unique identifiers in column A and columns B-M refer to Periods 01-12(months). each unique identifier may not have data start on the same period, meaning one site may have first data in period 01 and identifier 2 may have it in period 06. i wanted to see if there was a way to put a formula in that would allow me to compare data for each site in 3 months increments. i don't know if this makes sense but this is how it would look below. in the below example i am assuming there is only 6 periods because of table limitations. not sure if this makes sense but hopefully this diagram makes sense
not sure if this is possible, but i have a list of unique identifiers in column A and columns B-M refer to Periods 01-12(months). each unique identifier may not have data start on the same period, meaning one site may have first data in period 01 and identifier 2 may have it in period 06. i wanted to see if there was a way to put a formula in that would allow me to compare data for each site in 3 months increments. i don't know if this makes sense but this is how it would look below. in the below example i am assuming there is only 6 periods because of table limitations. not sure if this makes sense but hopefully this diagram makes sense
Biz Site | Period 01 | Period 02 | Period 03 | Period 04 | Period 05 | Period 6 | 3 month difference | 6 month difference | 9 month difference |
ABC | 2.00 | 4.00 | 6.00 | 8.00 | 10.00 | 4.00 | |||
BCD | 1.00 | 2.00 | 3.00 | 4.00 | 5.00 | 6.00 | 2.00 | 5.00 | |
EFG | 5.00 | 7.00 | 9.00 | 4.00 |