Hi,

I have a listview ctrl from which i need to extract a summary.
This listview is populated from access db. My listview is like:

Strategy No: Strategy Group Project Name
9 10 ABC Project
13 12 CDS Enhancement and Support
25 15 Delta Techops T&M
41 10 bbbbbbbb
41 15 cccccccccc

I want the output to be entered to a new excel sheet in following output:

Strategy Group Projects
10 2
12 1
15 2
Total Projects 5

I'm able to transfer whole listview data to excel. But how to get the count of unique items from a column?
i.e. count of each Strategy group is there in listview column 2?

Pls help. Thanks in advance.