Dear Ptm0412,
I have seen that you have used this formula to change a 2D range into 1D Range:
Q2 = INDEX(X,INT((P2-0.01)/2+1),P2-INT((P2-0.01)/2+1)*2+2)
(in the clock chart).
It is a little difficult to me, but I could try to understand. The problem is that I want another formula to fill down, through all the gaps between the data's rows.
Within the clock chart in post # 39, I can do with the column P, the formula is:
P2 = 1
P3 = IF(AND(P2<>0,MOD(P2,2)=0),0,IF(P2=0,P1+1,P2+1))
then fill down.
It is OK. But when I try Q2:
Q2 = IF(P2>0,INDEX(X,INT((P2-0.01)/2+1),P2-INT((P2-0.01)/2+1)*2+2),0)
or:
Q2 = IF(P2>0,INDEX(X,INT((P2-0.01)/2+1),P2-INT((P2-0.01)/2+1)*2+2),"")
or
Q2 = IF(P2>0,INDEX(X,INT((P2-0.01)/2+1),P2-INT((P2-0.01)/2+1)*2+2),NA())
Then fill down, the chart came to the wrong way.
Now I want a formula so that I can fill down, and the chart remain its performance. Or at least, is there any way to do faster than copy and paste each time 4 cells up to over 240 cells?
I have seen that you have used this formula to change a 2D range into 1D Range:
Q2 = INDEX(X,INT((P2-0.01)/2+1),P2-INT((P2-0.01)/2+1)*2+2)
(in the clock chart).
It is a little difficult to me, but I could try to understand. The problem is that I want another formula to fill down, through all the gaps between the data's rows.
Within the clock chart in post # 39, I can do with the column P, the formula is:
P2 = 1
P3 = IF(AND(P2<>0,MOD(P2,2)=0),0,IF(P2=0,P1+1,P2+1))
then fill down.
It is OK. But when I try Q2:
Q2 = IF(P2>0,INDEX(X,INT((P2-0.01)/2+1),P2-INT((P2-0.01)/2+1)*2+2),0)
or:
Q2 = IF(P2>0,INDEX(X,INT((P2-0.01)/2+1),P2-INT((P2-0.01)/2+1)*2+2),"")
or
Q2 = IF(P2>0,INDEX(X,INT((P2-0.01)/2+1),P2-INT((P2-0.01)/2+1)*2+2),NA())
Then fill down, the chart came to the wrong way.
Now I want a formula so that I can fill down, and the chart remain its performance. Or at least, is there any way to do faster than copy and paste each time 4 cells up to over 240 cells?
Lần chỉnh sửa cuối: