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.

Item No.Issues in Apple's Numbers


Post Reply New Thread Subscribe

 
Thread Tools
crimsondragon67

 
Member Since: Feb 13, 2013
Posts: 5
crimsondragon67 is on a distinguished road

crimsondragon67 is offline
Hi Guys,

maybe this is an elementary question but as a new user of Apple's Numbers I cant seem to find any answer to my question.

I have to organise a huge movie dvd library and have a spread sheet done ok in Numbers with 5 columns. the first column is No. as I want each line to start with an item number.. the 2nd column is Movie Description which needs to be sorted alphabetically etc..

However when I input all the data and go to sort the 2nd column (Movie Name) in ascending order the item no. is also changing so the first No. column is all out off sync etc. Is there a way of sorting out all the other colums but keeping the item No.column static so that it reads 1 -100 say and all the Movie descriptions in alphabetical order like the following:

Movie Name Released Video /Audio Description File Size
1. Avatar 2012 Bluray HD DTS 7.1 1080p 25.6Gb
2. JFK 1991 True HD DTS 5.1 1080p 19.96Gb

or do you leave out the numbering column and rely on page numbering in the printing menu at the end?

I am totally new to Numbers and know this is probably elementary but i can;t stop the number column from changing too when i sort the movie name column alphabetically.
Hopefully someone can please help
many thanks
Fergus
QUOTE Thanks
RadDave

 
RadDave's Avatar
 
Member Since: Jan 20, 2012
Location: North Carolina
Posts: 1,556
RadDave is a glorious beacon of lightRadDave is a glorious beacon of lightRadDave is a glorious beacon of lightRadDave is a glorious beacon of lightRadDave is a glorious beacon of lightRadDave is a glorious beacon of light
Mac Specs: MBP 13" (2013); 2.6 GHz i5; 8 GB RAM; SSD 256 GB; OS 10.10.1

RadDave is online now
Quote:
Originally Posted by crimsondragon67 View Post
Hi Guys,

maybe this is an elementary question but as a new user of Apple's Numbers I cant seem to find any answer to my question.

I have to organise a huge movie dvd library and have a spread sheet done ok in Numbers with 5 columns. the first column is No. as I want each line to start with an item number.. the 2nd column is Movie Description which needs to be sorted alphabetically etc..

However when I input all the data and go to sort the 2nd column (Movie Name) in ascending order the item no. is also changing so the first No. column is all out off sync etc. Is there a way of sorting out all the other colums but keeping the item No.column static so that it reads 1 -100 say ..................
Hi Fergus - I have about a half dozen simple databases in Numbers, all my personal needs (e.g. movies, wine recommendations, films to see & those seen, etc.) Attached is a 'screen capture' of the start of my 'DVD/BD' movie list - the films in bold are Blu-ray discs.

Numbers will keep a numeric listing of the rows to the far left (part of the sheet) fixed as you sort on the other columns; of course if you have Headers & spacer rows, then your first film will not be 'No. 1' - not sure how important that might be for you; otherwise you'll have to find a way in Numbers to 'Freeze' a column from a sort - Dave
.
Attached Images
File Type: png Screen Shot 2014-06-22 at 1.15.25 PM.png (236.2 KB, 10 views)
QUOTE Thanks
Slydude

 
Slydude's Avatar
 
Member Since: Nov 16, 2009
Location: North Louisiana, USA
Posts: 6,738
Slydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant future
Mac Specs: 2.8 GHz MacBook Pro 10.8,3 8 GB mem, 2.66 GHz Mac Pro - Dead, iPhone 4

Slydude is offline
@OP I have not used Numbers much at all but have used Excel For some time. If I understand your problem correctly this is probably going to happen with any spreadsheet. When you sort the information by a certain column, in this case title, everything associated with that title moves with it so the information is kept together on the same row.

If you have something like RadDave has set up then you get the layout he has shown. In Excel a Macro could be used to count the number of rows and subtract the header row(s) thus giving a count of the total number of DVDs.

Sylvester Roque Former Contributing Editor About This Particular Macintosh

"Got Time to breathe. You got time for music." Denver Pyle as Briscoe Darling
QUOTE Thanks
cradom

 
cradom's Avatar
 
Member Since: Feb 14, 2004
Location: Nederland, Texas
Posts: 3,394
cradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant future
Mac Specs: 21in iMac core2 Duo- 13in macbook - 10.9 on both

cradom is offline
Just thinking out loud...
How about if you select everything EXCEPT the numbers column and then sort?

Craig Domingue - resident redneck.
“Never argue with an idiot. He will only bring you down to his level and beat you with experience.”, George Carlin
QUOTE Thanks

Post Reply New Thread Subscribe


« Mail application problems | Safari open multi tabs on startup »
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

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
How to paste item on full page view? mikehende OS X - Operating System 1 05-21-2014 12:50 PM
Numbers 3.2 (new) Page numbering removal iPad-hubby OS X - Apps and Games 12 04-09-2014 08:08 AM
Frustrated with the Numbers App neilf OS X - Apps and Games 1 04-08-2014 02:48 PM
Opening numbers document on iPhone Farmer Pug iOS and Apps 2 03-31-2014 07:41 AM
Diagonal line in Numbers cells MacInWin OS X - Apps and Games 0 03-24-2014 10:58 PM

All times are GMT -4. The time now is 12:11 AM.

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?