Results 1 to 4 of 4
  1. #1


    Member Since
    Feb 13, 2013
    Posts
    5
    Item No.Issues in Apple's Numbers
    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

  2. #2

    RadDave's Avatar
    Member Since
    Jan 20, 2012
    Location
    North Carolina
    Posts
    3,274
    Specs:
    MBP 13" (2013); 8 GB RAM; SSD 256 GB; OS 10.11.5
    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 Attached Images

  3. #3

    Slydude's Avatar
    Member Since
    Nov 15, 2009
    Location
    North Louisiana, USA
    Posts
    9,934
    Specs:
    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

  4. #4

    cradom's Avatar
    Member Since
    Feb 14, 2004
    Location
    Groves, Texas
    Posts
    4,528
    Specs:
    21in. iMac 10.11 --- HP win 10
    Just thinking out loud...
    How about if you select everything EXCEPT the numbers column and then sort?
    Delusions are often functional. A motherís opinions about her childrenís beauty, intelligence, goodness, et cetera ad nauseam, keep her from drowning them at birth.
    -Lazarus Long

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Set alert for when status of item in apple store changes
    By bryanschmideler in forum iPhone Hardware and Accessories
    Replies: 1
    Last Post: 05-02-2015, 02:32 PM
  2. apple icon menu item gone
    By uhanepono in forum OS X - Operating System
    Replies: 4
    Last Post: 08-04-2014, 07:28 PM
  3. Apple's iPhone most popular item on eBay in 2010
    By the8thark in forum Apple Rumors and Reports
    Replies: 0
    Last Post: 12-29-2010, 07:51 AM
  4. G4 STARTING ISSUES broken item on board.
    By darque in forum Apple Desktops
    Replies: 2
    Last Post: 04-05-2010, 05:47 PM
  5. Correlating Model Numbers and Apple Part Numbers
    By fziksman in forum Other Hardware and Peripherals
    Replies: 0
    Last Post: 01-30-2007, 04:41 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
  •