Hi, I have a list of Account User IDs (Column 1) and a list of email addresses(column 2) associated with that user. I need to count the number of unique email addresses per user and display this on each row (column 3).
The data I have is stored in tables so I need the formula to allow for Calculated fields. e.g. below:
Any help would be appreciated.
M.
<tbody>
</tbody>
The data I have is stored in tables so I need the formula to allow for Calculated fields. e.g. below:
Any help would be appreciated.
M.
ID | <help> Count of Unique Email Addresses</help> | |
101 | 101a@excelquery.com | 1 |
101 | 101a@excelquery.com | 1 |
102 | 102a@excelquery.com | 2 |
102 | 102b@excelquery.com | 2 |
103 | 103a@excelquery.com | 1 |
104 | 104a@excelquery.com | 1 |
105 | 105a@excelquery.com | 1 |
106 | 106a@excelquery.com | 2 |
106 | 106a@excelquery.com | 2 |
106 | 106b@excelquery.com | 2 |
107 | 107a@excelquery.com | 1 |
<tbody>
</tbody>