Drag Formula cell to decrement the cells

  • Thread starter Thread starter Asher Zur
  • Start date Start date
A

Asher Zur

I have a 20 different values starting from A1 till T1
I need to do automatically (by dragging a formula cell) that U1=T1
V1=S1, W1=R1 ........... AN=A1 (mirror of A1 till T1)
Can someon
 
In U1 put =A1 and then just copy across to AN1. Select U1:AN1 and do Edit /
replace / replace = with %%. Select U1:AN1 and do Edit / Sort, hit options and
choose right to left and then choose to sort in descending order. Now do Edit /
replace / Replace %% with =.
 
Back
Top