Count Unique Duplicates

[NetriX]

Hi there,

Glad to be here. Hoping someone could help with my issue.

Scenario:

Data table A is "dynamic". Each time a connection is refreshed, new data is inserted into column "A".

What I'd like to be able to do is produce in column "E" for example, all duplicate values and then count the referenced amount in column adjacent (for example "F").

Would love a VBA function.

Thanks!

 

[sheetspread]

The pivot table with a dynamic named range does this easily