Hi,
I have 2 sheets. Below is the scenario.
In sheet1, I have a set of columns having the User IDs.
In sheet2, I have the User Ids and number of account IDs. Acoount Ids can be duplicated for the user IDs
In sheet1, I have to calculate the unique number of acoount Ids for each users.
Please refer attached Excel sheet for sample data
Please advise
Thanks.
Bookmarks