Hi all,
I'm having a bit of a brain explosion over this so should I would register for some help.
I have a spreadsheet which has 3 columns. Column A contains a list of computer names, Column B contains a list of services, column C contains the status of the service.
What I want is to count all the unique values from column A where column C has an entry of 'stopped'. The idea is that I can use this for reporting the number of devices which have any service in a stopped state. an example of the table is as follows:
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
I'm having a bit of a brain explosion over this so should I would register for some help.
I have a spreadsheet which has 3 columns. Column A contains a list of computer names, Column B contains a list of services, column C contains the status of the service.
What I want is to count all the unique values from column A where column C has an entry of 'stopped'. The idea is that I can use this for reporting the number of devices which have any service in a stopped state. an example of the table is as follows:
Computer | Service | State |
PC01 | Service 1 | Running |
PC01 | Service 2 | Stopped |
PC01 | Service 3 | Stopped |
PC02 | Service 1 | Running |
PC02 | Service 2 | Running |
PC02 | Service 3 | Running |
PC03 | Service 1 | Stopped |
PC03 | Service 2 | Running |
PC03 | Service 3 | Running |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>