I think adjust it's fine, but in my understanding, sometimes wrong, it must be in the same way like Copy/Paste, adjust relative references and retain absolute references, like it is supposed a spreadsheet works. It's an user matter use properly relative/absolute references.
changing C9 value to 500,
after Menu/Data/Sort - Column C descending / Options - Range contain column labels.
now in
A5: =IF(C5<C9;RANK(C5;$C$2:$C$16;0);IF(C5>C9;"Re-sort";IF(AND(C5=C9;B5<B9);"Re-sort";"")))
seems that references to the same row are updated properly (C5), but references to other rows change in a strange way for me (C8->C9), maybe they have several changes while sorting.
Forgive me, but I can't see why keep relative references changed in a different way than Copy/Paste, when a priori you don't know what data finish in what row.
I think most times comparisons/sums are with previous/next row, like in the sample, or to sum all the previous or all the rest rows/columns.
I think adjust it's fine, but in my understanding, sometimes wrong, it must be in the same way like Copy/Paste, adjust relative references and retain absolute references, like it is supposed a spreadsheet works. It's an user matter use properly relative/absolute references.
Now with sample in https:/ /bugs.freedeskt op.org/ show_bug. cgi?id= 83276:
A9: =IF(C9< C8;RANK( C9;$C$2: $C$16;0) ;IF(C9> C8;"Re- sort";IF( AND(C9= C8;B9<B8) ;"Re-sort" ;"")))
changing C9 value to 500, C9;RANK( C5;$C$2: $C$16;0) ;IF(C5> C9;"Re- sort";IF( AND(C5= C9;B5<B9) ;"Re-sort" ;"")))
after Menu/Data/Sort - Column C descending / Options - Range contain column labels.
now in
A5: =IF(C5<
seems that references to the same row are updated properly (C5), but references to other rows change in a strange way for me (C8->C9), maybe they have several changes while sorting.
Forgive me, but I can't see why keep relative references changed in a different way than Copy/Paste, when a priori you don't know what data finish in what row.
I think most times comparisons/sums are with previous/next row, like in the sample, or to sum all the previous or all the rest rows/columns.