Hi All,

I have a problem with taking count.

Item List 1 Status Item List 2 Status Item List 3 Status
AAA N AAA N CCC N
BBB N AAA Y SSS N
DDD N WWW N EEE N
AAA N EEE N HHH Y
BBB N SSS Y WWW N
RRR N DDD N DDD Y


From the Above table I want to take a count of all the Items in the which has a status "N" in the corresponding status column. And i want to list Top 3 Items

The output will be like this:

Top 3 Items

Item Count
AAA 3
BBB 2
DDD 2

And if i click(dbl-click) in the count it should drill down and show the corresponding records.
How can i achieve this using VBA Coding???Is it possible to do this using Pivot table???

Thanks in advance,
Nithin