Hi,
I have a list over 1000 items long, with some repeats. I want to count the number of discrete items in the list, as I show in the image below. How many times does Alpha occur? How many times does Beta occur?
The Count function won't do what I want.
TIA.
edg
iMac 27″, macOS 10.15
If you using Numbers 11.2 that takes about 3 seconds using a Pivot Table.
Click the table and choose Create Pivot Table from the Organize Menu:
Drag down into the Rows and Values areas:
Giving you the result:
If you using Numbers 11.2 that takes about 3 seconds using a Pivot Table.
Click the table and choose Create Pivot Table from the Organize Menu:
Drag down into the Rows and Values areas:
Giving you the result:
guitar_edg wrote:
SG,
The pivot table functions won't work with only one column of data. You need 2 columns.
I used just one column of data for my screenshots above. The trick is to drag down once into the Rows area, and then then also drag down into the Values area. It's dead simple. You may be overthinking it (as I did on my first try). These Pivot Tables are really easy and flexible.
SG
You've probably discovered, as I did, that via the menu you get the choice to put on same sheet whereas via the Toolbar you don't get the choice.
Excellent video tutorial on use of Pivot tables in Numbers at:
https://macmost.com/the-new-pivot-table-feature-in-numbers.html
SG
Hi SGIII,
I am on an iMac, on version 11.2 Below is a screen shot of my version of Numbers. It does not resemble yours.
I do have a Pivot Table button, but it just creates a new Sheet.
I will continue to try & figure this out.
Thanks,
edg
SG,
Some times I am not so bright. The pivot table functions won't work with only one column of data. You need 2 columns.
I watched the video a few times, and I finally got it. It should not be so hard, I would think. But I got it.
Thanks,
edg
I never used pivot tables before today, not in Excel either. I see that pivot tables do not automatically update when the source data changes. If your data changes, you have to refresh the pivot table if you want it to reflect the changes. In Numbers it is pretty simple, using the circular arrow in the sidebar.
The formula-based solutions to the question you asked here will stay updated automatically, but they are a lot more complicated than a pivot table.
Never mind, I found it. Id10T that I am :)
edg
Counting items in a list
