URGENT! NUMBERS in MAC

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