Hi Excel Gurus,
I get a weekly vulnerability report showing me what machines need patches. Often 1 patch will fix several vulns.
What I need is the total amount of patches needed per machine.
In the past, I have copied unique cells and used a countif to determine the counts of vulns, patches and machines which need patches. But that was for only the column I wanted to count.
Any help would be appreciated.