PDA

View Full Version : Flow chart

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

xld
05-29-2008, 08:31 AM
A2: =CHAR(MOD(CODE(A1)-96,4)+97)

copy down.

sasa
05-29-2008, 10:31 AM
Thanks, xld,
But I get this error "Name?"

sasa
#NOME?

grichey
05-29-2008, 10:35 AM
His formula is meant to go in A2 and filled down to wherever. The only hard coded char is the one in A1 which then effects change throughout the rest of the range. This works for me.

sasa
05-29-2008, 10:40 AM
can you send me your file ?

grichey
05-29-2008, 11:52 AM
Here's the file with the formula in A2:A31 with the value 'a' in A1.

sasa
05-29-2008, 11:02 PM
Thanks, it is ok, but as I asked I have from time to time the need to face some missing characters. Is there the possibility to have the same formula working also if from a2 to a 31 miss some characters ( one o more than one missing in a random way ?).