Getting String from cell and inserting it into a formula

**Davtho1983** · 06-19-2015, 05:25 AM

Hi in Excel I have a column of unique server names, a column of servers and a column of patches applied to servers. It looks something like the picture below.

First I need to go through each servername in the first column, and count the occurrences of that servername in the second column.

Then I need to put each servername into a COUNTIFS formula that counts the occurrences of a particular patch per servername - the one on my spreadsheet looks like this:

=COUNTIFS(A:A,"servername",C:C,"Patch 1")+COUNTIFS(A:A,"servername",C:C,"Patch 2")

I cannot seem to find a way to make VBA go down a list of undefined length of servernames, putting the servername into the COUNTIFS formula each time? I think I need to get the cell value as a string and insert that string into a formula, but I have no idea how.

**JoeFoot** · 06-19-2015, 06:05 PM

see if this is what you want:

Please Login or Register  to view this content.

I might be confusing your request but it seems you want to count the number of patch occurences in each unique server. If so should your COUNTIFS be referencing "B:B" instead of "A:A"? Isn't columnA where you keep your unique names?

Or I might be missing something. See if this helps.