I have a list of coins that are bought at different exchanges in Column A. The exchanges are listed in column B. Some coins are bought from 2 or more exchanges so there may be entries that look like this:
<tbody>
</tbody>
I've created a summary table that lists balances by coins and I'm trying to include the exchange a coin was purchased at. I don't think index/match will work. This is what I'm looking for:
<tbody>
</tbody>
There may be several exchanges to be retrieved. Any ideas?
Thanks in advance
Coin A | Exchange 1 |
Coin B | Exchange 2 |
Coin A | Exchange 3 |
<tbody>
</tbody>
I've created a summary table that lists balances by coins and I'm trying to include the exchange a coin was purchased at. I don't think index/match will work. This is what I'm looking for:
Coin A | Exchange 1, Exchange 3 | |
Coin B | Exchange 2 | |
<tbody>
</tbody>
There may be several exchanges to be retrieved. Any ideas?
Thanks in advance
Last edited: