Group Rows into Categories gone in new Numbers

Use the Feedback tool in the Numbers menu.

I'm keeping a list if stuff that's "gone missing". Just added Category View to my list.

Jerry

I can believe it either that this feature is gone!!! It was the reason I liked more Numbers than Excell!

I hope it comes bak soon!!!

the reason I liked more Numbers than Excell!

Actually I like Excel's pivot tables more than the old Categories, RIP.

Have you considered using SUMIFS and COUNTIFS?

The big advantage to this formula-based approach (over both the old Numbers's Categories and Excel's Pivot Tables) is that the results are easily used for ongoing calculations or for making charts.

SG

I'm keeping a list if stuff that's "gone missing". Just added Category View to my list.

Jerry

______________________________

Jerry,

I know that this post was a year ago, but do you still maintain that list of Numbers 2.3 features that are missing in Numbers 3? I would be very interested to read it.

Thanks,

Simon.

Simon,

Keeping a "missing" list is less satisfying now because it's so much shorter than it was back then. Categories (the subject of this thread) is still on it. So is ease of seeing how document will look in print. Also some niche things such as import of OFX files (from financial institutions).

Meanwhile, the "new" features list continues to grow: dramatically better cross-platform sync, much improved AppleScript support, easier Pop-Up Menu, improved Conditional Highlighting (Formatting), Interactive Charts, Transpose Rows and Columns.

SG

Thanks for that. One of my spreadsheets does make use of Categories so I would miss that.

I have another spreadsheet that makes extensive use of some complicated nested functions. In Numbers 2.3 I can edit the function at the top of the screen and expand that area to see the formula in its entirety. I'm a little worried that Numbers 3.5 doesn't easily cope with editing large formulas. Here is an example of one such formula:

=(VLOOKUP(B3,HL Holdings,MATCH(-1,HL Holdings :: $1:$1,0),FALSE)-VLOOKUP(B3,HL Holdings,MATCH(-5,HL Holdings :: $1:$1,0),FALSE))/VLOOKUP(B3,HL Holdings,MATCH(-5,HL Holdings :: $1:$1,0),FALSE)

Do you have a view on how well Numbers 3.5 manages entering/editing of such lengthy nested functions?

Thanks,

Simon.

Here's a screenshot of the formula editor in Numbers 3.5:

As you can see, plenty of room (it can go much bigger than this).

You just have to know that from its default size (smaller than shown here) you can pull it as wide and tall as you want by dragging on the edges.

SG

Thanks SG - unfortunately, all I can see is a white question mark in a little blue box.

For some reason the screenshot is not showing for me. Is is something I'm doing wrong? 😕

No that's a problem with the forum. Very irritating. Sometimes double-clicking the blue box helps to see the image, and sometimes it doesn't.

The image was of your formula above as it looks the Numbers 3.5 formula editor, which I had dragged large so formula occupied only about a third of the space (which could be made larger still, just by further dragging on the edges).

Once you learn how to resize the editor you won't have any problem handling very, very, very long formulas.

SG

Thanks SG. That's reassuring.

Still can't see the screenshot - pity I'm quite curious to see what it looks like.

Thanks again,

Simon.

Can anyone help me: I have a master table of data:

I want to be able to create tables from this which can sort by "month" and "category", like an excel pivot table (i.e. updates automatically after I enter data in the master table, giving me 12 separate tables (Jan to Dec) each sorted by category.)

OBM,

Please post this question as a new discussion.

Jerry

And see the example using SUMIFS above. You would set up 12 separate summary tables. Each of these will update automatically when you make changes in the master table. (BTW, I do not believe Excel pivot tables update automatically; after making changes in the source data, the user has to "Refresh".)

Sorry for repeating a question Jerry.

SG, the SUMIFS seems to work a treat. I bow to your genius! Thanks a lot.

David

I'm having trouble visualizing what is happening here. How does the second parameter in the sumif become the first column in the new table? What points it there?

What does the third parameter (A2 Name) do since it never shows up in the new table? Why is it even in the formula at all?

I've tried figuring out what the fifth parameter does from the help file but cannot see what cell B1 has to do with anything at all in the new table or the old one. Why is it even there?

Is the first parameter in the sumifs always the one that is getting summarized?