You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Dear All,
I have created one row with 9 numbers, please see below.
How do I sort these 9 numbers in ascending or descending order using NUMBERS in Mac?
Please note, I do not wish to sort rows by choosing a specific column. I want to sort the numbers in a specific row.
Kind regards,
George
854, 76, 98, 21, 2, 66, 52,8, 10
The built-in sorting is by columns, not rows; it moves the rows around (sorts ascending or descending) but does not change the order of the columns. You can use a formula in another row that puts your numbers in sorted order but it will not sort your original row or the table.
If your numbers are in cells A1:I1 the formula in cell A2 would be =SMALL($A1:$I1,COLUMN())
Fill right with that formula to complete row 2 and it will have tour values in sorted order.
If you take a look at the descriptions of those functions (SMALL and COLUMN) you can find out how to modify the formula to fit your actual table.
=LARGE($A1:$I1,COLUMN()) will put them in the opposite order.
If you truly need the table sorted by your row of numbers, you can do it manually. Click on one of the column letters at the top of the column then click again and hold and drag the column to a new spot. Repeat this until the table is sorted.
The built-in sorting is by columns, not rows; it moves the rows around (sorts ascending or descending) but does not change the order of the columns. You can use a formula in another row that puts your numbers in sorted order but it will not sort your original row or the table.
If your numbers are in cells A1:I1 the formula in cell A2 would be =SMALL($A1:$I1,COLUMN())
Fill right with that formula to complete row 2 and it will have tour values in sorted order.
If you take a look at the descriptions of those functions (SMALL and COLUMN) you can find out how to modify the formula to fit your actual table.
=LARGE($A1:$I1,COLUMN()) will put them in the opposite order.
If you truly need the table sorted by your row of numbers, you can do it manually. Click on one of the column letters at the top of the column then click again and hold and drag the column to a new spot. Repeat this until the table is sorted.
For sorting the numbers in one row, I'd use the SMALL or LARGE functions as suggested by Badunit.
To sort the table columns using the values in that row, you could try this:
Start with:
With the table selected, go to the Table menu and choose Transpose.
With this result:
Sort ascending on column B:
And Transpose again:
I adjusted the width of the columns after each transposition to reduce them for the image shots here, but that can be left to the final version without affecting the results.
Regards,
Barry
Thank you ever so much for your prompt reply and for teaching me how to solve my problem.
All the best for you,
George
Thank you Barry so much for going to great length to enhance Batunit's reply. Your input was equally very useful and enlightening.
My best regards to you too,
George
URGENT! NUMBERS in MAC
