Hello everyone,
I have been trying for quite a while to find a way to automate/quickly determine the total number of unique values in a filtered (drop-down) cell. In the attached document, I have a customer who has multiple accounts associated with her personal ID. Every month, I need to process quite a few customers who have multiple accounts and therefore require special further processing.
If I use a filter and expand it on column D, I can immediately see that a record has multiple accounts. But how can I quickly find out the total of unique accounts of a customer and write that total to another column so I can use conditions to further process those with multiple accounts?
Any recommendations would be highly appreciated--I spent quite a few days trying to find a solution.
Thank you in advance for your time,
Miruna
I have been trying for quite a while to find a way to automate/quickly determine the total number of unique values in a filtered (drop-down) cell. In the attached document, I have a customer who has multiple accounts associated with her personal ID. Every month, I need to process quite a few customers who have multiple accounts and therefore require special further processing.
If I use a filter and expand it on column D, I can immediately see that a record has multiple accounts. But how can I quickly find out the total of unique accounts of a customer and write that total to another column so I can use conditions to further process those with multiple accounts?
Any recommendations would be highly appreciated--I spent quite a few days trying to find a solution.
Thank you in advance for your time,
Miruna