Hi All,
I am trying to do a software license reconciliation at work. I have written a VB Script that searches our servers for installed software and dumps that into a spreadsheet with the server name as the column heading and the software installled on that server listed underneath.

What I cant figure out is how to go through this data and write the name of the software into a new column (or sheet) with a count of how many times it appears in the spreadsheet indicating how many licenses I need.

Some servers have different software so I need a way to scan what has already been counted and listed against what has not yet been counted (i.e, count how many times the string in A3 appears in spreadsheet, write string A3 and how many times it is installed, move to A4 compare to A3, compare to software already counted and if unique count instances and write string A4 and number of instances.... move to B3 compare to A3,A4... Z120 etc, repeat until all entries have been counted).

This is doing my head in

 

Example

A1 = OFFICE

B1:B99 = Scanned Applicaions

=COUNTA(B1:B99,A1) = your answer

 

cheers Gazza-uk.

I tried that and a bit of everything else but found out that if I reformatted the sheet I could macro a Pivot table which seemed the business for the boss...