selective counting of repeated elements (VBA macro)

[buhnen]

Hi everybody,

I've already started this thread within the General Help sub-forum but found out that the way I'm looking for is regarded to VBA programming. That's why I'm "moving" my post into here.

This is the original thread:

http://www.excelforum.com/excel-2007...ml#post2327343

I hope someone can help me. Thanks in advance!

[Leith Ross]

Hello buhnen,

I have added a new worksheet with a button to run the macro. The new sheet shows the unique entries and the count of each. These changes have been added to the attached workbook.

Please Login or Register  to view this content.

[stanleydgromjr]

buhnen,

Are you trying to find out how many times the unique strings in column A are found in columns B and C?


Detach/open workbook AdvancedFilter Unique - Selective counting of repeated elements - buhnen - VP - SDG13.xls, and run macro CountUnique.


The above macro ran in 5 seconds on my Lenovo T61 laptop.

[buhnen]

buhnen,

Are you trying to find out how many times the unique strings in column A are found in columns B and C?


Detach/open workbook AdvancedFilter Unique - Selective counting of repeated elements - buhnen - VP - SDG13.xls, and run macro CountUnique.


The above macro ran in 5 seconds on my Lenovo T61 laptop.

Hi Stanley,
Thanks for your attempt but what I was intending to do was to count only the repeated values within the column A. Those values are tags that I will later print out, so I need to know how many of them I have to print. In the end what I needed was like Leith Cross did.

Now I'm trying to find out how to mark with SOLVED this thread...