New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus • Advice and insight from world-class Apple enthusiasts • Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Iwork Numbers - Question About Sorting, Video Game Collection


Post Reply New Thread Subscribe

 
Thread Tools
Sleepless87

 
Member Since: May 25, 2010
Posts: 15
Sleepless87 is on a distinguished road

Sleepless87 is offline
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...
QUOTE Thanks
Collin Bl

 
Collin Bl's Avatar
 
Member Since: Apr 07, 2009
Location: Napier NZ
Posts: 3,281
Collin Bl is a jewel in the roughCollin Bl is a jewel in the roughCollin Bl is a jewel in the rough
Mac Specs: 27 iMac i5, MBP 13 & iMac 20, 2TB dual TC, AppleTV, iPh4S

Collin Bl is offline
Welcome to the Forum. So `Sort Descending' is not what you want? Seems that would do the trick.
QUOTE Thanks
Sleepless87

 
Member Since: May 25, 2010
Posts: 15
Sleepless87 is on a distinguished road

Sleepless87 is offline
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...
QUOTE Thanks
Collin Bl

 
Collin Bl's Avatar
 
Member Since: Apr 07, 2009
Location: Napier NZ
Posts: 3,281
Collin Bl is a jewel in the roughCollin Bl is a jewel in the roughCollin Bl is a jewel in the rough
Mac Specs: 27 iMac i5, MBP 13 & iMac 20, 2TB dual TC, AppleTV, iPh4S

Collin Bl is offline
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.
QUOTE Thanks
Sleepless87

 
Member Since: May 25, 2010
Posts: 15
Sleepless87 is on a distinguished road

Sleepless87 is offline
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...
QUOTE Thanks
Sleepless87

 
Member Since: May 25, 2010
Posts: 15
Sleepless87 is on a distinguished road

Sleepless87 is offline
And in alphabetical order which comes first generally?

Uncharted: Drake's Fortune
OR
Uncharted 2: Among Thieves
QUOTE Thanks
Sawday

 
Sawday's Avatar
 
Member Since: Nov 19, 2006
Location: York, UK
Posts: 1,014
Sawday is a jewel in the roughSawday is a jewel in the roughSawday is a jewel in the rough
Mac Specs: 24" Aluminium, 2.8 GHz, 4Gb RAM. iPad2, iPhone4

Sawday is offline
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.
QUOTE Thanks
Sleepless87

 
Member Since: May 25, 2010
Posts: 15
Sleepless87 is on a distinguished road

Sleepless87 is offline
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...
QUOTE Thanks

Post Reply New Thread Subscribe


« copy install ? | Windows media player »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

All times are GMT -4. The time now is 08:45 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?