Count Text & Unique numbers in Text Box

[l4ya]

Hello,

In my attached sheet there are two textboxes. In textbox1, I would like to see count of unique numbers visible numbers in column D, and in textbox2, i would like to see count of visible text "Yes" from column C. Can someone help? Thanks.

[rylo]

Hi

In a general module in the workbook, enter the following code

Please Login or Register  to view this content.

Then
C1: =mycountif(C3:C34,"Yes")
D1: =mycountuniq(D3:D34)

When you change your filters, these should give you the results you are chasing.

If you then put in a sheet event (right click on the sheet tab, select view code)

Please Login or Register  to view this content.

then the results of the UDFs will be put into your textboxes.

HTH

rylo