Drag Formula cell to decrement the cells

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

Asher Zur

Ken,
I do thank you for your prompt assistance.
The solution you gave me works fine but with limited No. of cell
(sorting problem)
is there a way to do it in an unlimited No. of cells (e.g. 50 or 6
cells - BI till DP to be the mirror of A till BH )
Thanks Agai
 
Sure, just follow instructions as before and in BI1 put =A1 and copy across to
DP1. Now do the replace bit to get %%, BUT, now in BI2 put 1, in BJ2 put 2, in
BK2 put 3 and fill across to DP2. Select BI1:DP2, do Data / Sort / descending /
right to left but choose Row2 to be the one to sort on.
 
Back
Top