Counting the article

Hi All,

I have set of data in a column and I need to count of how many of them are there. I have a huge data more than a 200000. I had tried with countif() formula. But it take huge time. I am looking for macro or a VB code to do so. Please find the attachment.

Why can not you use Pivot Table?

I will come across some situation like I need to take for particular counts. Example like I need to only 2 fruits from the column.

maybe so

Please Login or Register  to view this content.

Hi sathishkm

Try this code, put in module

Please Login or Register  to view this content.

A+

Another:

Please Login or Register  to view this content.

Thank You.