Let me explain.
I have two worksheets in my excell workbook.
One sheet we will call ApplicationName
second sheet we will ImportTable.
In Sheet 1 (ApplicationName) I have:
<column1> . <column 2> (using Countif function)
MSWORD . Total# of servers from ImportTable where MS Word is there
MS Excell . Total# of servers from ImportTable where MS Excell is there
MS PPS . Total# of servers from ImportTable where MS PPS is there
In sheet 2 - (ImportTable) I have
<column1> . <column2> . <column3>
ServerA . MSWORD . Level0
ServerB . MSWORD . Level0
ServerC . MS Excell . Level1
ServerD . MSPPS . Level0
ServerE . MSPPS . Level1
ServerF . MSWORD . Level2
ServerG . MSExcell . Level2
ServerH . MSWORD . Level1
ServerI . MS PPS . Level2.
.
Now what I want to do is the following:
In Sheet1 - Application - I want to add a column that will match the Application name and then count the number of Level0's assigned and another column where the same criteria counting Level1 etc..
So that I can see a breakdown of how many level0, level1, and level2's are there for each application.
I am using 2010
Thoughts??
Bookmarks