ExcelIron ContributorMar 14, 2022Sorting a Number Hello Everyone, I want to arrange the list of amounts in such a way that, $48 comes in the first place and $24.78 goes to the last, basically I want to reverse the list. It should be resul...Show MoreBook6.xlsx15 KB
LorenzoSilver ContributorMar 14, 2022Hi Excel Assuming numbers & no blanks in A1:A17 (edited): =IF(ROW()-ROW(A$1) = 0, A$17, IF(ROW()-ROW(A$1)+1 = ROWS(A$1:A$17), A$1, A1) )
LorenzoSilver Contributor to ExcelMar 14, 2022Revised the formula with something easier given what you want to achieve
LorenzoSilver Contributor to ExcelMar 14, 2022Revised the formula with something easier given what you want to achieve
