Consecutive Win / Loss

[ashishmehra2010]

Hi,

I am looking for a code that pull out the consecutive number of Win or Loss for a team.

Regards,
AM

[Vikas_Gautam]

your proposed answer..?

[ashishmehra2010]

your proposed answer..?

Here is the proposed answer.

Regards,
AM

[Vikas_Gautam]

Here is the formula:-

Please Login or Register  to view this content.

Check the attached file for further instruction:-

[ashishmehra2010]

Here is the formula:-

Please Login or Register  to view this content.

Check the attached file for further instruction:-

Hi Vikas,

Can you please select other teams in cell E1 & check if the results are correct.

Regards,
AM

[Vikas_Gautam]

Okay this is what is showing when I filtered for INDIA. I am not getting any Consecutive Loss. Do You..?
or I am not getting you as wish me to.

Yes, India has won 2 times Consecutively. But Didn't lost 2 back to back matches.

Do you agree..?

[ashishmehra2010]

Okay this is what is showing when I filtered for INDIA. I am not getting any Consecutive Loss. Do You..?
or I am not getting you as wish me to.

Yes, India has won 2 times Consecutively. But Didn't lost 2 back to back matches.

Do you agree..?

Hi Vikas,

Yes, you are right there is no consecutive loss when I select India; unfortunately the formula is not getting the correct output when I select West Indies there are 5 consecutive wins & 2 loss.

The proposed answer are

Regards,
AM

[Vikas_Gautam]

Okay this is the new formula for your new requirement.

Please Login or Register  to view this content.

Here is what I got when I filtered for West Indies. As much as I can see, there is only one consecutive loss. and 4 back to back wins. Do you agree on this.?

the New formula give 4 consecutive wins and 1 consecutive loss.

Actually the proposed results you have provided are very inconsistent while considering each team one by one.

Check the attached file:-

[ashishmehra2010]

Okay this is the new formula for your new requirement.

Please Login or Register  to view this content.

Here is what I got when I filtered for West Indies. As much as I can see, there is only one consecutive loss. and 4 back to back wins. Do you agree on this.?

the New formula give 4 consecutive wins and 1 consecutive loss.

Actually the proposed results you have provided are very inconsistent while considering each team one by one.

Check the attached file:-

Hi Vikas,

Kindly refer to this link http://stats.espncricinfo.com/wi/con...ds/126874.html

Aus has the highest 21 wins consecutively in One Day International Cricket.

Regards,
AM

[Vikas_Gautam]

I think, Finally this will do.
That espncricinfo link was the difference.

Please Login or Register  to view this content.

Check the attached file:-

[ashishmehra2010]

I think, Finally this will do.
That espncricinfo link was the difference.

Please Login or Register  to view this content.

Check the attached file:-

Hi Vikas,

The formula is working fine & I appreciate your effort.

What I want is a macro which will give the number of consecutive Win or Loss as I enter the data in ODI-DATA sheet.
I hope I sound clear enough.

Can you please check the attached file which contains real data.

Courtesy: espncricinfo.com

Regards,
AM

[x65140]

You just have to remap the fields....see if this is what you want.

[ashishmehra2010]

You just have to remap the fields....see if this is what you want.

Thanks x65140 but I want the result through macro.

Regards,
AM

[Vikas_Gautam]

Here is one way.

Use the Drop down and see the difference. I have used Status bar for the status.

I have Used a Helper column to make thinks easier.

Check the attached file:-

[ashishmehra2010]

Here is one way.

Use the Drop down and see the difference. I have used Status bar for the status.

I have Used a Helper column to make thinks easier.

Check the attached file:-

Thanks Vikas for your time & effort. The code looks fine to me; let me test this on my real data.
I may need your extended support as I have more questions on this data.

Regards,
AM