This question was asked in Counting Unique Values in Excel
In 4 question 
How to solve it?

Ash KîÑg's image