sasa
05-29-2008, 07:21 AM
Hi All,
this is my question:
Considered a1=a, a2=b,a3=c,a4=d, is it possible to arrange a formula that works this way: if I have a1=a, then automatically a2=b, a3=c, a4=d, if I have a1=b, than a2=c, a3=d, a4= a, if I have a1=c, then a2=d, a3=a, a4=b and so on. If some item are missing the formula should work the same way, for example it could take the characters from another column, the B, for example, b1=a, b2=c, b3=d and working in the same way. The result: a1=a, a2=c, a3= d, and so on. Finally this formula should grab the last item of the previous sequence, in the first example what is in a4, in the second example what is in a3 and should work again the same way for 31 rows.
Thanks for any help
sasa
this is my question:
Considered a1=a, a2=b,a3=c,a4=d, is it possible to arrange a formula that works this way: if I have a1=a, then automatically a2=b, a3=c, a4=d, if I have a1=b, than a2=c, a3=d, a4= a, if I have a1=c, then a2=d, a3=a, a4=b and so on. If some item are missing the formula should work the same way, for example it could take the characters from another column, the B, for example, b1=a, b2=c, b3=d and working in the same way. The result: a1=a, a2=c, a3= d, and so on. Finally this formula should grab the last item of the previous sequence, in the first example what is in a4, in the second example what is in a3 and should work again the same way for 31 rows.
Thanks for any help
sasa