Iwork Numbers - Question About Sorting, Video Game Collection

Sleepless87 · Sleepless87 #1 (**permalink**)

05-25-2010, 02:49 AM

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...

Collin Bl · Collin Bl #2 (**permalink**)

05-25-2010, 05:36 AM

Welcome to the Forum. So `Sort Descending' is not what you want? Seems that would do the trick.

Sleepless87 · Sleepless87 #3 (**permalink**)

05-26-2010, 12:05 AM

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...

Collin Bl · Collin Bl #4 (**permalink**)

05-26-2010, 04:37 AM

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.

Sleepless87 · Sleepless87 #5 (**permalink**)

05-27-2010, 11:21 AM

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...

Sleepless87 · Sleepless87 #6 (**permalink**)

05-27-2010, 11:23 AM

And in alphabetical order which comes first generally?

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

Sawday · Sawday #7 (**permalink**)

05-27-2010, 12:18 PM

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!

Sleepless87 · Sleepless87 #8 (**permalink**)

06-01-2010, 10:05 PM

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...

Sawday #7 (permalink)
Member Since: Nov 19, 2006 Location: York, UK Posts: 871 Mac Specs: 24" Aluminium, 2.8 GHz, 4Gb RAM. iPad2, iPhone4	05-27-2010, 12:18 PM 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

Iwork Numbers - Question About Sorting, Video Game Collection

Internet Services

Web Development

Digital Marketing

Consumer Tech

Sleepless87 #1 (permalink)
Member Since: May 25, 2010 Posts: 13	05-25-2010, 02:49 AM 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 #2 (permalink)
Member Since: Apr 07, 2009 Location: Napier NZ Posts: 3,273 Mac Specs: 27 iMac i5, 2.4 C2D MBP & iMac 20, 1TB dual TC, AppleTV, iPh4	05-25-2010, 05:36 AM Welcome to the Forum. So `Sort Descending' is not what you want? Seems that would do the trick.
	QUOTE Thanks

Collin Bl #4 (permalink)
Member Since: Apr 07, 2009 Location: Napier NZ Posts: 3,273 Mac Specs: 27 iMac i5, 2.4 C2D MBP & iMac 20, 1TB dual TC, AppleTV, iPh4	05-26-2010, 04:37 AM 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 #5 (permalink)
Member Since: May 25, 2010 Posts: 13	05-27-2010, 11:21 AM 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 #6 (permalink)
Member Since: May 25, 2010 Posts: 13	05-27-2010, 11:23 AM And in alphabetical order which comes first generally? Uncharted: Drake's Fortune OR Uncharted 2: Among Thieves
	QUOTE Thanks

Sleepless87 #8 (permalink)
Member Since: May 25, 2010 Posts: 13	06-01-2010, 10:05 PM 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

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)