Welcome to iPadForums.net Guest - Click Here to Register

Problems sorting colums in numbers

This is a discussion on Problems sorting colums in numbers within the New Member Introductions - Site Assistance forums, part of the Apple iPad Discussions category; I still can not duplicate the sorting problem. Which is confusing since we are using the same version. But, I did some major work on ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 11 to 19 of 19
  1. #11
    iPF Legend
    Member #
    28530
    Liked
    1526 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,436
    I still can not duplicate the sorting problem. Which is confusing since we are using the same version.

    But, I did some major work on the Results table. Mostly to entertain myself and as self education, but you may find it useful.

    By using the INDEX function instead of directly linking to Table 1, I managed to keep the formulas from breaking when sorting. Note that the # column is used as part of the INDEX statement, so editing this will break things. You can sort by it though, to get your original order back. I formatted the # column to numbers. It was automatic, and sorting as text: 1, 10, 11…16, 2, 3…9 instead of 1, 2, 3…16.

    I got tried of seeing zeros and error flags, so I used some IF and IFERROR functions to clean up the results. I also extended the rank function to include all 16 rows in the table, otherwise sorting in descending order in the Rank column in the Results table broke the function.


    Try importing this version of the spreadsheet and see if it now works. If you need a more detailed explanation of what I did, feel free to ask, but you should probably read the descriptions of each function first so we're talking on the same points.

    I've tacked a _3 on the end to differentiate the files from the earlier two.
    https://www.dropbox.com/s/vw6eys7hrs...1212_3.numbers

    If this does not work, all I can suggest is deleting and re-installing Numbers on the iPad. If you are syncing with iCloud, your documents should re-sync when you turn iCloud syncing back on in Settings > Numbers. If not using iCloud, or as an added precaution (recommended), export your documents to DropBox (as Numbers files). It's fairly easy to re-import them from the DropBox app.
    Last edited by twerppoet; 12-14-2012 at 03:39 PM. Reason: numerous erros and mistakes

  2. Ads


  3. #12
    iPF Novice
    Member #
    265432
    Join Date
    Dec 2012
    Posts
    10
    Thanks,

    I Will look at it and report back.

  4. #13
    iPF Novice
    Member #
    265432
    Join Date
    Dec 2012
    Posts
    10
    Hi There,


    Thanks, it looks much better without the error flags. Also the sorting suddenly works.

    I have two new problems though.
    1. In the RESULTS table the % column now displays the points in stead of the percentage. From row 9 in stead of row 10. I tried to change the REF, but then the ranking stops working and the nasty error flags are back.

    2. I am unable now to input the names via the form. Probably a small thing, but I can't solve it. Not even if I make a new form.

    Thanks for all the help so far.

  5. #14
    iPF Legend
    Member #
    28530
    Liked
    1526 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,436
    1. My fault. I accidentally selected the points instead of the percentage column in the formula. Rather than trying to talk you through correcting the formula I'll just post the corrected version _4 here. It's kind of a nice change, anyway. Instead of a long IF statement to detect nulls, I was able to simplify it an use IFERROR.

    https://www.dropbox.com/s/ie558bh42z...1212_4.numbers

    On the other hand, if you fix the error flag for that row in Table 1 the formula will have to be adjusted again. If you do that and can't figure out how to use the IF statement, let me know. The Names column still uses the IF statement, so you can use that as a template.

    2. Oops. That would be because I changed the number of header rows from 1 to 2. I did that when I was playing around with sorting on Table 1. I've undone that damage as well.

    It's an interesting sheet you're working on. It's been a pleasure playing with it.

  6. #15
    iPF Novice
    Member #
    265432
    Join Date
    Dec 2012
    Posts
    10
    Hi Twerppoet,


    Everything works the way I want. I was able to use the IFERROR statement in the big table in the percentage row, so it looks better now.
    Thanks a million, I. Couldn't have done it alone. I still do not know why the sorting did not work, but what is important is that it works now.
    Stay well, I might need your brain at some other time

    TXs

  7. #16
    iPF Legend
    Member #
    28530
    Liked
    1526 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,436
    That's great!

    Out of curiosity, and if it's not a secret, what kind of tournament are you tracking? I couldn't quite figure it out, though I suspect some type of card game.

  8. #17
    iPF Novice
    Member #
    265432
    Join Date
    Dec 2012
    Posts
    10
    It was bridge

    regards

  9. #18
    iPF Legend
    Member #
    28530
    Liked
    1526 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,436
    Ah, Bridge.

    Our high school basket ball team got to go to state one year. Rather than shut down the school the remaining teachers and students came up with some fun classes to wile away the time. I spend about a week learning Bridge in one class. I remember almost nothing, except that it was a lot more complicated than seemed strictly necessary. Hold in mind this was the same kid who was spending most of the rest of the day playing chess. Losing, mostly, but playing.

    Thanks. Enjoy the games.

  10. #19
    Administrator
    Member #
    48665
    Liked
    949 times
    Join Date
    Apr 2011
    Location
    Brisbane, Australia
    Posts
    23,496
    Hi and welcome to the Forum!

    So glad Twerppoet was able to help you......he really is amazing with his knowledge!

    The IPad Forum is a community of members from all walks of life and from all over the world coming together to share our experiences and to help each other learn about this wonderful piece of technology the Ipad. There is a wealth of information already here in the many threads we have so doing some searches will answer most of the questions you have. If then you cannot find the answer you are seeking then by all means post your question. There are many friendly and informed members here only too willing to help you.

    We also have our own App - It is a very simple app to navigate.
    http://itunes.apple.com/us/app/discu...412896524?mt=8
    Tutorial on creating posts on the Forum
    Creating Posts and Starting New Threads - How To
    Reading the IPad manual is a great place to start so please download a copy of these.
    http://www.support.apple.com/manuals/ipad/
    3 very informative threads from which you will learn many tips and shortcuts for the IPad.
    http://www.ipadforums.net/ipad-gener...dont-know.html
    iOS5 Tips and Tricks
    Easy pictorial shortcuts & Helpful places. - For People new to the iPad.
    We have rules like any Community so please read these also
    Forum rules - everybody please read!!

    Once again we welcome you here and are so pleased you have joined us!

    Please read the Forum Rules
    iPad Air 128gb Wifi/Cellular - iPad 2 64gb Wifi/Cellular - iPad Mini 32gb Wifi/Cellular - iPhone 5 - Apple TV - MacBook Pro 15" - Time Capsule - Airport Express


Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Similar Threads

  1. Sorting Cells in Numbers
    By delsandberg in forum iPad Apps
    Replies: 1
    Last Post: 09-11-2012, 04:54 PM
  2. Icloud problems syncing numbers, and pages
    By Normlambert in forum iPad General Discussions
    Replies: 0
    Last Post: 01-14-2012, 01:13 PM
  3. Problems getting Numbers file back from iCloud
    By KevBec27606 in forum iPad General Discussions
    Replies: 1
    Last Post: 12-29-2011, 08:16 PM
  4. Sorting in Pages and Numbers?
    By SherryG in forum iPad Apps
    Replies: 1
    Last Post: 06-24-2010, 06:38 AM
  5. Sorting in Pages and Numbers?
    By SherryG in forum iWork Forum
    Replies: 1
    Last Post: 06-17-2010, 11:33 PM

Search tags for this page

numbers

,

numbers ipad sort column

Click on a term to search for related topics.