Solved: Filter data and count unique

[herzberg]

My problem is, the combobox adds the list repeatedly in the combobox each time I activate the sheet. I just need the items to appear only once, not reproducing itself each time I activate it.

That's simple; clear the combo box before populating it then, e.g. :
[vba] Private Sub Worksheet_Activate()
With ComboBox1
.Clear
.AddItem "Active Issues 0 to 30 days old"
'Etc...
End With
End Sub[/vba] In this way, the combo box will not continue appending items to the bottom.

As for the rest, check out the attachment. Too lengthy to type all out here.