Hi All,
I have a a long output of machine names and software and am trying to output the software based on a drop down menu. I then want to count how many times that software is present, also based on the drop down menu.
For instance: This is what I am trying to achieve where B3 contains the value in the drop down menu. Column C will contain every piece of software relevant to B3 and D3 will count how many times that software is installed on a computer with B3 in the Device Name
Here is a sample of the raw data:
Any ideas where to start with this one?
Many thanks in advance!
I have a a long output of machine names and software and am trying to output the software based on a drop down menu. I then want to count how many times that software is present, also based on the drop down menu.
For instance: This is what I am trying to achieve where B3 contains the value in the drop down menu. Column C will contain every piece of software relevant to B3 and D3 will count how many times that software is installed on a computer with B3 in the Device Name
Here is a sample of the raw data:
Any ideas where to start with this one?
Many thanks in advance!