Results 1 to 8 of 8
  1. #1


    Member Since
    May 25, 2010
    Posts
    15
    Unhappy Iwork Numbers - Question About Sorting, Video Game Collection
    Hi,

    I'm listing my video game collection using Iwork Numbers. But I don't like the way it sorts ascending. For example:

    I have "Uncharted: Drake's Fortune" and "Uncharted 2: Among Thieves" in my list. I click on "Sort Ascending" and when I do that, second game comes first in the list! What can I do to make the first game on top?

    I don't want that type of sorting:

    Uncharted 2: Among Thieves
    Uncharted: Drake’s Fortune

    I want this:

    Uncharted: Drake’s Fortune
    Uncharted 2: Among Thieves

    Please help, thanks...

  2. #2

    Collin Bl's Avatar
    Member Since
    Apr 07, 2009
    Location
    Napier NZ
    Posts
    3,292
    Specs:
    27 iMac i5, MBP 13 & iMac 20, 2TB dual TC, AppleTV, iPh4S
    Welcome to the Forum. So `Sort Descending' is not what you want? Seems that would do the trick.

  3. #3


    Member Since
    May 25, 2010
    Posts
    15
    Yes but I want them to be listed alphabetically. So I want the first game on top. When I was using Excel on Windows 2 years ago, when I alphabetically listed them, the first games (Uncharted: Drake's Fortune) were on top. So what can I do to fix that on Numbers? I think that Numbers take "2" before ":" in order. So I think I must change that. I'm waiting for your answers, thanks...

  4. #4

    Collin Bl's Avatar
    Member Since
    Apr 07, 2009
    Location
    Napier NZ
    Posts
    3,292
    Specs:
    27 iMac i5, MBP 13 & iMac 20, 2TB dual TC, AppleTV, iPh4S
    Changing sort order in the way you want is not something i can help with. I would put a character in front of uncharted to force the sort order.

  5. #5


    Member Since
    May 25, 2010
    Posts
    15
    to sleazy
    Why does it take "space2" before than the ":" in Mac. If it doesn't on Windows, maybe it can be change on Mac somehow? Anyway thanks...

  6. #6


    Member Since
    May 25, 2010
    Posts
    15
    And in alphabetical order which comes first generally?

    Uncharted: Drake's Fortune
    OR
    Uncharted 2: Among Thieves

  7. #7

    Sawday's Avatar
    Member Since
    Nov 19, 2006
    Location
    York, UK
    Posts
    1,210
    Specs:
    24" Aluminium, 2.8 GHz, 4Gb RAM. iPad2, iPad mini2, iPhone5s
    In my days as a datamanager I'd get round this by creating an extra column called 'Sort Order Name' or some such. Make this equal to the name field (copy/paste or use a formula) for all your records except for the awkward ones. For example for your two problem records the Sort Order Name could be 'Uncharted1' and 'Uncharted2'. Then sort on the Sort Order Name field and you're sorted so to speak!
    Happiness is not getting what you want, but wanting what you get.

  8. #8


    Member Since
    May 25, 2010
    Posts
    15
    Thanks, it did work!
    So I must keep this column there all the time and hide it.
    This type of work is usefull for video game collection list because its not that long.

    But for my movie list, I add new titles so often. And list has about 5000 movies. So I can't predict which titles are awkward. Got any practical idea for that too? Anyway thanks for your all help...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. iWork/Numbers question
    By Matt Strader in forum OS X - Apps and Games
    Replies: 4
    Last Post: 12-19-2010, 01:02 AM
  2. iWork 09 Numbers Question
    By PinkPotions in forum OS X - Apps and Games
    Replies: 3
    Last Post: 01-14-2010, 05:44 PM
  3. Numbers (iWork) Question
    By Mark W in forum Switcher Hangout
    Replies: 1
    Last Post: 10-05-2008, 10:07 AM
  4. iWork 08 - Numbers Question
    By mac57 in forum OS X - Apps and Games
    Replies: 0
    Last Post: 09-30-2008, 11:02 PM
  5. iWork Numbers question?
    By pruppert in forum OS X - Apps and Games
    Replies: 0
    Last Post: 09-03-2007, 04:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •