1

I would like to sort a column in ascending or descending order by number of objects in Numbers. However, despite setting the 'data format' as 'number' it doesn't understand the right order.

This is the ascending order of the column in Numbers:

1 apple
1300 oranges
16000 peanuts
671 mangos
91 potatoes

When I want it to be in this order:

1 apple
91 potatoes
671 mangos
1300 oranges
16000 peanuts

Please, see screenshot:

enter image description here

1
  • 2
    separate the number out, in a helper column, then sort on that column. Use left()...
    – Solar Mike
    Jan 2 '21 at 9:32
2

I think by adding a word to each number you've forced it to sort strictly alphabetically, which does make 1, 1300, 16000 etc 'correct'. Removing the letters should revert to natural sorting.

Moving the words to a separate column should fix it. An easy way to split the numbers out for searching is to add a column between B and C and set =LEFT(B2, SEARCH(" ", B2) - 1) as a formula there.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .