Check out Eliminating Or Merging Duplicate Rows In Numbers at YouTube for closed captioning and more options.
Eliminating Or Merging Duplicate Rows In Numbers
Comments: 5 Responses to “Eliminating Or Merging Duplicate Rows In Numbers”
This is brilliant!
Hmmm... I could follow you but I definitely couldn't repeat you. Thanks for showing me how much more I need to learn about Numbers basics.
Gary, you are terrific. If I had to figure this out from the manual...it would never happen. Thank you soooooo much. PS: Can you add PayPal acct to your donation options please.
I'm wondering why you wouldn't just use 'sumif' as in this example: https://discussions.apple.com/thread/7814195?start=0&tstart=0
It seems simpler and would automatically update with revised underlying data (the only exception would be if a new type of item is added to the count list then it needs to be added to the summary list.
Pat: Not sure how this applies. People need to remove duplicate rows in Numbers and sometimes combine the information in them. SUMIF is great for calculating sums if you want to keep multiple items in their own rows, but only in that case.