4 June 2010, 4:13 pm
======> the direction goes from left tot right a4=A1-B1b4=B1-C1c4=C1-D1=D1-E1=E1-F1=F1-G1 From left to right but when i want to transpose them the formula reference changens this is the direction i need to transpose the cells from left to right =====> to down so wheni drag them down the reference keeps going grom left to right . But when i transpose the formula changes Is there a macro or a way to transpose them without excel changing them. I want to drag it down and but it needs to go from down =A1-B1 =B1-C1 =C1-D1 =D1-E1 =E1-F1 =F1-G1 || || || || v Question no2 What do i need to put in the formulag so excel jumps one letter up when dragging down. this is simmular like the quesition above a2=abs(a1-b2) a3=abs(b1-c2) a4=abs(c1-d2)... Read More »
Share on del.icio.us
Share on digg
Share on Technorati
Share on reddit
Share on Yahoo!
Share on Furl
