View Full Version : Flow chart

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

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

copy down.

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


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.

Is that not your goal?

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

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

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 ?).


05-29-2008, 11:43 PM
Flow Chart in this way. If a then b, but if b is missing, then c, then d, and again.

Thanks again