SOLVED

Query related to Excel

Iron Contributor

Hello Everyone. 

 

i want to filter how many incident for CPU and memory related alerts, need to filter server name?

 

Please help..

 

Here is a attached file...

 

 

2 Replies
best response confirmed by Excel (Iron Contributor)
Solution

@Excel 

Please give your discussions a more relevant subject. ALL topics in this forum are related to Excel.

 

See the attached version. I added two helper columns with formulas to extract the host and the type of alert.

You can use these for filtering, and/or for a pivot table.

Thank you so much sir.
1 best response

Accepted Solutions
best response confirmed by Excel (Iron Contributor)
Solution

@Excel 

Please give your discussions a more relevant subject. ALL topics in this forum are related to Excel.

 

See the attached version. I added two helper columns with formulas to extract the host and the type of alert.

You can use these for filtering, and/or for a pivot table.

View solution in original post