Excel VBA Tips
Search This Blog
Wednesday 20 June 2012
COUNT UNIQUE ENTRIES FROM A LIST OF DUPLICATE DATA
Formula in B2:
=SUMPRODUCT(1/COUNTIF(A2:A11,A2:A11))
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment