Hi All,

i want to get the unique count in sheet 1 using formula but please note the data is present in Sheet 2.

Sheet 2

Column A Column B
A123 completed
A456 In progress
A789 Not Started
A123 Completed.

So i want to get the unique count of completed in Sheet 1.

Thanks in advance.
Vishnu Balan