How to Count Unique Values Among Duplicates

Dear beloved friend,

Could any one help telling the formula to count unique value or text among the duplicate in airtable?

Thanks in advance and regard,

I don’t think this is doable via formulas actually. What about linked fields and using the array unique as the aggregation formula?