I am aware of count and counta


I would like to know if we can perform a count or counta excluding the duplicate entires in a range i.e A1:A1000


Range - 100 Entries

Original Entires - 300
Duplicate Entries - 700

Expected Result of =Count should be 300

Please advise