sommerfeld
New Member
- Joined
- Apr 4, 2016
- Messages
- 12
Hi, can anyone help with with this problem.
I have a list of data where I've done a conditional format to identify duplicate email addresses. I've tagged each email address relevant to the user's interest. So imagine you had a user who had three interests and another with 2 and another with 1 and another with 3 etc. How could I get the output so that if a duplicate value exists, one adjacent cell contacts their interests all in one cell and not separately? Example of below of what I mean and the desired output.
Many thanks in advance!!
Antony
<tbody>
</tbody>
I have a list of data where I've done a conditional format to identify duplicate email addresses. I've tagged each email address relevant to the user's interest. So imagine you had a user who had three interests and another with 2 and another with 1 and another with 3 etc. How could I get the output so that if a duplicate value exists, one adjacent cell contacts their interests all in one cell and not separately? Example of below of what I mean and the desired output.
Many thanks in advance!!
Antony
Interest | Desired Output | |
Oranges | ab@xyz.com | Oranges and Pears and Bananas |
Pears | ab@xyz.com | Oranges and Pears and Bananas |
Bananas | ab@xyz.com | Oranges and Pears and Bananas |
Oranges | cd@xyz.com | Oranges |
Pears | ef@xyz.com | Pears and Bananas |
Bananas | ef@xyz.com | Pears and Bananas |
<tbody>
</tbody>