Getting the count of a text

See more:

VBA

Hello All,

This is kind of irritating me,

Now i have an excel sheet which has some rows. Find below the example

Service        Status        
-------        -------
Value 1        OnGoing
Value 1        Completed
Value 2        OnGoing

I have another sheet which contains a combo box and in the combo box, i have value1 and value 2 as the items. Now when i click on Value 1 i should get 1 ongoing and 1 completed, But what i am getting as result is 2 as ongoing and 1 as Completed. How do i sort this out?

Thanks.