Hi,
I have selected the cells AI1:AI5 and each of those cells contain the formulas given below,
Here, i want to convert only A1,A2,A3,A4,A5 into $A$1,$A$2,$A$3,$A$4,$A$5 at once leaving R1,R2,R3,R4,R5,R6 as it is.=IF(OR(A1=R1)*(A1=R2),A1,"")
=IF(OR(A2=R1)*(A2=R2)*(A2=R3),A2,"")
=IF(OR(A3=R2)*(A3=R3)*(A3=R4),A3,"")
=IF(OR(A4=R3)*(A4=R4)*(A4=R5),A4,"")
=IF(OR(A5=R4)*(A5=R5)*(A5=R6),A5,"")
Please forward me if any idea exists to perform such time saving modifications.
Thanks
Bookmarks