i want to start the autofill the concatenate from last argument.
like in B1 =Concatenate(A1,A2,A3) then i want
B2 =Concatenate(A4,A5,A6)
so in this example if 1st formula end with A3 then next formula in otherline start with next A4 not with A2.
if somebody have can help tell how i can do that .. it will be awesome.. thanks in advance
like in B1 =Concatenate(A1,A2,A3) then i want
B2 =Concatenate(A4,A5,A6)
so in this example if 1st formula end with A3 then next formula in otherline start with next A4 not with A2.
if somebody have can help tell how i can do that .. it will be awesome.. thanks in advance