Copy cell contents to another table without Duplications

I have a pool that I administrate and I have been manually inputting a lot of the data. I would like to find a way to "automate" the following functions. I apologize in advance if the answers are somewhere within the forum but I have been unable to locate them.


Question #1:


I want to fill all the names from the Player columns in Table 1 into Table 2 but not duplicate the entries. Would I use some form of the LOOKUP function?


Question #2:


I would like the amounts I fill in next to the Players in Table 2 Winnings column to copy to the corresponding Players Winnings column in Table 1.


Question #3:

I have 25 Weeks and 20 Participants in my sheets. I am using a dropdown list for choosing the Players in Table 1. I know that Numbers 09 cannot populate that dropdown list from another dynamic list so I could update them in just one place. I know this is possible in Excel but can it be done in the new version of Numbers?


Here is an example of what the sheets would look like:


TABLE 1 TABLE 2

User uploaded file

Thanks for any assistance with this.

- James

Numbers 09-OTHER

Posted on Jan 20, 2014 7:12 AM

Reply
21 replies

Feb 26, 2014 7:52 AM in response to Moradiya Paras

Moradiya Paras wrote:


But what is if column contain no text only numbers


Are you referring to extracting distinct values? If you are, then you could also use this Automator Service (Dropbox download). Doubleclick the .workflow package and it will self-install itself in your Library > Services folder (you may have to click 'download anyway' in System Preferences > Privacy & Security) and appear as a menu pick in your Numbers > Services menu. Select the cells with the duplicates, choose "Copy Distinct" from the menu, click once on the upper cell of the range where you want the "deduplicated" values, and paste.


SG

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Copy cell contents to another table without Duplications

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.