Forum Discussion

yashank_p's avatar
yashank_p
Copper Contributor
Jun 17, 2024
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...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 18, 2024

rachel 

If for legacy Excel we may add one more

For Account ID

=IFERROR(
   INDEX(
      accountID,
      AGGREGATE(15,6,
         (ROW(accountID)-ROW($A$1)) /
         (COUNTIF($E$14:E14, accountID)=0),
          1)
   ), "" )

for # of Domains

=IF(
   $E15="",
   "",
   SUMPRODUCT(--(accountID=$E15)/COUNTIFS(DomainName,DomainName) )
 )

and drag both down

rachel's avatar
rachel
Steel Contributor
Jun 18, 2024
Brilliant! That is exactly why excel is fun!