simplychelsea9
New Member
- Joined
- Jan 29, 2015
- Messages
- 2
Hello! I am working on a project that is totaling overall values over a certain period, but I am having trouble with the last part, which is finding certain strings in a given range, then counting how many times they appear.
For example, I have this range of data in an excel sheet:
<tbody>
</tbody>
So let's say in cell F13, if I am checking the range for error messages in the ActionMessage Column and want to place the result in F13, I need it to appear like:
Failure: Access denied (2)
Failure: Password Error (1)
Alternatively, if Success if found, I don't want it to list anything.
I don't even know how to begin though.. Do I make an array and then use countif statements? A little push in the right direction would be greatly appreciated because I am completely lost right now. Thanks!
For example, I have this range of data in an excel sheet:
Action | Date | TargetID | ActionMessage |
Reset | 10/14/2014 | company.net | Failure:AccessDenied |
Reset | 10/14/2014 | company.net | Success |
Reset | 10/14/2014 | contractor.net | Success |
Reset | 10/14/2014 | consultant.net | Failure:PasswordError |
Reset | 10/14/2014 | company.net | Failure:AccessDenied |
<tbody>
</tbody>
So let's say in cell F13, if I am checking the range for error messages in the ActionMessage Column and want to place the result in F13, I need it to appear like:
Failure: Access denied (2)
Failure: Password Error (1)
Alternatively, if Success if found, I don't want it to list anything.
I don't even know how to begin though.. Do I make an array and then use countif statements? A little push in the right direction would be greatly appreciated because I am completely lost right now. Thanks!
Last edited: