Sorting from ascending orders.

ideliveryx welcome to the forum.

Try selecting/highlighting both columns of numbers (excluding the headers). Tab until the right hand column is the active column. Then click Data>Sort A-Z (smallest to largest). The other column will rearrange and maintain their relationships with the second column.

If that doesn't work we will need to see what the formula(s) are.

I think the formula has the same sheet reference, you have to remove the sheet name in formula
suppose you have two sheets - sheet1 & sheet2 and you are looking sort data in sheet2 in B2
you have the following formula =SUMIFS(Sheet1!$B$2:$B$11,Sheet1!$A$2:$A$11,Sheet2!$A2)
in this case you will not the sort will not work properly change the formula as
=SUMIFS(Sheet1!$B$2:$B$11,Sheet1!$A$2:$A$11,$A2) do it for all
if it will not works pls attach a sample excel file

@ ideliveryx
I think we are going to need a small Excel workbook that behaves the way you describe ... (not pics or screenshots ... saves retyping data and we can see this behavior in the context of the formulas)

To attach a file to your post,

• be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

is the numbers always between 0 to 9

Then
L5=SMALL(INDEX(COUNTIF($A$1:$G$9,ROW(INDIRECT("1:10"))-1),0),ROWS(L$5:L5))
K5=SMALL(INDEX((COUNTIF($A$1:$G$9,ROW(INDIRECT("1:10"))-1)<>$L5)*11+ROW(INDIRECT("1:10"))-1,0),COUNTIF(L$5:L5,L5))
Try this and copy towards down
see the attached file