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 ...
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.
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
12-14-2012 03:30 PM
I Will look at it and report back.
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.
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.
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.
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
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.
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.
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.
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.
3 very informative threads from which you will learn many tips and shortcuts for the IPad.
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
By delsandberg in forum iPad Apps
Last Post: 09-11-2012, 04:54 PM
By Normlambert in forum iPad General Discussions
Last Post: 01-14-2012, 01:13 PM
By KevBec27606 in forum iPad General Discussions
Last Post: 12-29-2011, 08:16 PM
By SherryG in forum iPad Apps
Last Post: 06-24-2010, 06:38 AM
By SherryG in forum iWork Forum
Last Post: 06-17-2010, 11:33 PM
Search tags for this page
numbers ipad sort column
Click on a term to search for related topics.