Adding rows based on a unique set from other table

Question

Level 1

8 points

Adding rows based on a unique set from other table

I have a set of data in a table and are making total based on the name given in the main data table

SUMIF($model;$A;Table 1::$total)

This works fine, but I need to manually add every possible entry as a row in that view table. Is this something that can be automated?

https://www.dropbox.com/s/ngd0qoanz9mom5s/Screenshot%202016-09-12%2016.06.20.png ?dl=0

thanks

OS X El Capitan (10.11.1)

Posted on Sep 12, 2016 7:10 AM

Reply

Answer 1

SGIII

Level 8

37,568 points

Sep 12, 2016 6:39 PM in response to Bas Kamer

If I understand you correctly you can use this Copy Distinct Automator Service (Dropbox download).

To install double-click the downloaded .workflow package and if necessary give permission at System Preferences > Security & Privacy. (You may also need to check Automator.app at System Preferences > Security & Privacy > Privacy > Accessibility.)

To use:

Select the cells in column containing the values.
Choose 'Copy Distinct' from your Numbers > Services menu.
Click once in the top destination cell.
Command-v or Edit > Paste and Match Style to paste.

You should have it up and working in less than a minute.

SG

Reply