Many thanks in advance for any help in this matter!
I've attached my problem as an image.
I have three portfolios on the left, each containing a selection of stocks.
I've then organised this into a table, with a list of the unique stocks in one column, and the names of each portfolio in their own columns. What is the formula that I would need to type in that would figure out that Stock A (for example) is held in both Portfolio 1 and 3?
As an extra question, I currently plan on creating the list of unique stocks by copy & pasting the whole list, and then pressing the 'remove duplicates' button under the Data tab. This will be a pain to repeat every time I add a new portfolio with a new selection of stocks etc., so is there any way to automate that process as well?
Really appreciate any help on this.
Bookmarks