LewisMCT333
New Member
- Joined
- Jun 1, 2016
- Messages
- 13
Hi Everyone, I hope you are able to help me, im using Excel 2010.
I have two columns one with a 9 digit number in which is effectively a transaction reference, the column next to it has either "Failure" or "Success" as a reference to the transactions process.
What I need to do is establish how many of these transactions that failed, did in fact eventually succeed. I was trying to achieve this using some form of =MATCH and calling the index for the cell but then I couldn't figure out how to check for the successful cell etc etc.
It seems very complicated to me, but it also feels like it shouldn't be and im maybe not seeing it clearly any more. Can anyone help? Thanks.
Kind Regards, Lewis -
I have two columns one with a 9 digit number in which is effectively a transaction reference, the column next to it has either "Failure" or "Success" as a reference to the transactions process.
300001147 SUCCESS 300001230 FAILURE 300001230 SUCCESS 300001245 SUCCESS 300001262 SUCCESS 300001263 SUCCESS 300001264 FAILURE 300001264 FAILURE 300001264 FAILURE 300001265 SUCCESS 300001266 FAILURE 300001266 SUCCESS 300001267 FAILURE 300001267 FAILURE 300001269 SUCCESS 300001270 FAILURE 300001270 FAILURE 300001270 FAILURE 300001271 SUCCESS 300001272 SUCCESS
<tbody>
</tbody>
What I need to do is establish how many of these transactions that failed, did in fact eventually succeed. I was trying to achieve this using some form of =MATCH and calling the index for the cell but then I couldn't figure out how to check for the successful cell etc etc.
It seems very complicated to me, but it also feels like it shouldn't be and im maybe not seeing it clearly any more. Can anyone help? Thanks.
Kind Regards, Lewis -