Sort Numeric Columns in Excel using Formulas

=RANK(C5,sales)+COUNTIF($C$5:C5,C5)-1

where “sales” is the named range C5:C11

References
https://exceljet.net/formula/basic-numeric-sort-formula