# Formula Help

#### bflan0524

##### Board Regular
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

 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

### Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

#### jmacleary

##### Well-known Member
Hi there. This should do it for you (I'm sure there may be simpler answers, but it does the job):
Book3 (version 1).xlsb
ABCDEFGHIJ
1Biz SitePeriod 01Period 02Period 03Period 04Period 05Period 63 month difference6 month difference9 month difference
2ABC2468104
3BCD12345625
4EFG5794
Sheet2
Cell Formulas
RangeFormula
H2:H4H2=IF(ISERROR(INDEX(B2:G2,1,2+MATCH(FALSE,ISBLANK(B2:G2),0))),"",INDEX(B2:G2,1,2+MATCH(FALSE,ISBLANK(B2:G2),0))-INDEX(B2:G2,1,MATCH(FALSE,ISBLANK(B2:G2),0)))
I2:I4I2=IF(ISERROR(INDEX(B2:G2,1,5+MATCH(FALSE,ISBLANK(B2:G2),0))),"",INDEX(B2:G2,1,5+MATCH(FALSE,ISBLANK(B2:G2),0))-INDEX(B2:G2,1,MATCH(FALSE,ISBLANK(B2:G2),0)))
J2:J4J2=IF(ISERROR(INDEX(B2:G2,1,8+MATCH(FALSE,ISBLANK(B2:G2),0))),"",INDEX(B2:G2,1,8+MATCH(FALSE,ISBLANK(B2:G2),0))-INDEX(B2:G2,1,MATCH(FALSE,ISBLANK(B2:G2),0)))
Press CTRL+SHIFT+ENTER to enter array formulas.

Replies
1
Views
51
Replies
11
Views
468
Replies
17
Views
172
Replies
5
Views
309
Replies
12
Views
125