Excel help on Count

[gkbabu4u]

Hi Team,

I have a dataset with the below format.

acct,date,resp-code
1234,0102,00
1234,0102,00
1234,0102,01
1234,0102,01
1234,0102,00
2341,0102,02

looking for the output in the below format.

acct,date,resp-code,count,SuccessRate

1234,0102,00,03
1234,0102,00,03
1234,0102,01,02
1234,0102,01,02
1234,0102,00,03
2341,0102,02,01,NeverSuccess1

Note:- Pivot should not be used.

SuccessRate to be mentioned as "NeverSuccess"with the transaction count if it does not have a respcode of 00 anytime.

Count should be calculated with combination of acct & resp-code

acct & resp-code are of fixed length.

Appreciate you help!!
Thanks in Advance.

 

[Peter_SSs]

Duplicate to: Search results

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.