Forum Discussion
yashank_p
Jun 17, 2024Copper Contributor
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...
- Jun 17, 2024
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.
rachel
Jun 18, 2024Steel Contributor
Came across this formula recently, quickly became one of my favourites:
=SUMPRODUCT(--($A$2:$A$9=F2),1/COUNTIFS($A$2:$A$9,$A$2:$A$9,$B$2:$B$9,$B$2:$B$9))
(can be drag down)