Forum Discussion
Solved
Formula Help: Count Unique Domains per Account ID
Hello Community! I have an Excel file with two columns: Account ID and Domain Name. A single Account ID can have multiple Domain Names associated with it. In other words, the relationship between...
The formula in the sample file returns the intended result. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.
If on Excel 365
=LET(
u, UNIQUE(accountID),
count, MAP(u, LAMBDA(a, ROWS(UNIQUE(FILTER(DomainName, accountID=a))) ) ),
VSTACK( {"Account ID","# of Domains"}, HSTACK(u, count))
)- Thanks, Sergei!
yashank_p , you are welcome
