06-22-2014, 08:50 AM #1
Item No.Issues in Apple's Numbers
- Member Since
- Feb 13, 2013
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
06-22-2014, 01:24 PM #2
- Member Since
- Jan 20, 2012
- North Carolina
- MBP 13" (2013); 8 GB RAM; SSD 256 GB; OS 10.11.4
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
06-22-2014, 01:48 PM #3
- Member Since
- Nov 15, 2009
- North Louisiana, USA
- 2.8 GHz MacBook Pro 10.11, 8 GB mem, iPhone 6+
@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
06-22-2014, 03:05 PM #4
Just thinking out loud...
How about if you select everything EXCEPT the numbers column and then sort?Always listen to experts. They’ll tell you what can’t be done and why. Then do it!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By bryanschmideler in forum iPhone Hardware and AccessoriesReplies: 1Last Post: 05-02-2015, 02:32 PM
By uhanepono in forum OS X - Operating SystemReplies: 4Last Post: 08-04-2014, 07:28 PM
By the8thark in forum Apple Rumors and ReportsReplies: 0Last Post: 12-29-2010, 07:51 AM
By darque in forum Apple DesktopsReplies: 2Last Post: 04-05-2010, 05:47 PM
By fziksman in forum Other Hardware and PeripheralsReplies: 0Last Post: 01-30-2007, 04:41 PM