Multiple entries in a cell

[Marquis76]

Hi,

I've been looking for hours for a solution - to no avail. I'm keeping track of my dividends in my stock portfolio. I have multiple accounts, at different banking institutions, some registered some non-registered. I'm using a code for each (i.e. 1-11). Sometimes, I buy the same stock in multiple accounts. Since dividend amounts are the same and paid on the same date for all accounts, I'm looking to register multiple values (i.e. accounts with the dividend-paying stock) under Account in my excel sheet, to avoid duplicating the dates in order to enter each value separately for each account. My sheet looks like this:

Date​	Dividends​	Account​
2017-03-31​	$21​	10,11​
2017-06-30​	$22​	10,11​
2017-09-17​	$22​	10,11​
2017-12-29​	$22​	10,11​
2018-03-29​	$22​	10,11​
2018-06-29​	$23​	10,11​
2018-09-28​	$23​	10,11​
2018-12-31​	$23​	10,11​
2019-03-29​	$23​	10,11​
2019-06-28​	$24​	10,11​
2019-09-30​	$24​	10,11​
2019-12-31​	$24​	10,11​
​	​	​
​	​	​
​	​	​

Then, each individual account sums up all dividends paid for this stock, per account. However, my problem is that I am unable to get excel to "read" cells with multiple values in them. Help! Thanks a million

 

[Marquis76]

Yes, the actual expected result is shown in AE8. AE8 is unable to read properly Q12 if there are multiple accounts listed.

 

[Peter_SSs]

As I mentioned (twice) before, I cannot identify what columns are what in what you posted. Same with rows. Therefore I cannot identify what is AE8 or Q12.

You also have not addressed what I have asked (twice) before about the expected results

how did you get them manually?