Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Thanks in advance,
I have following sheet
S.no. Marks Yes/no
1. 13. No
2. 16. yes
3. 18. yes
4. 19. No
5. 22 yes
6. 24. yes
7. 26. yes
8. 33. No
9. 35. No
10. 12. yes
11. 17. No
12. 38. yes
13. 40. yes
14. 42. yes
15. 44. yes
16. 46. yes
My query is I want to know how many times
1. 'continuesly three time yes' in third column - come in the above sheet
2. 'continuesly two time yes' in third column - come in the above sheet
3. 'Maximum time continues yes' in third column - comes in the above sheet
And is
1. Three time yes comes only one time
2. Two time yes comes only one time
3. Maximum time continues yes comes is 5
Please provide the VBA code or any formula for the above three point
I have following sheet
S.no. Marks Yes/no
1. 13. No
2. 16. yes
3. 18. yes
4. 19. No
5. 22 yes
6. 24. yes
7. 26. yes
8. 33. No
9. 35. No
10. 12. yes
11. 17. No
12. 38. yes
13. 40. yes
14. 42. yes
15. 44. yes
16. 46. yes
My query is I want to know how many times
1. 'continuesly three time yes' in third column - come in the above sheet
2. 'continuesly two time yes' in third column - come in the above sheet
3. 'Maximum time continues yes' in third column - comes in the above sheet
And is
1. Three time yes comes only one time
2. Two time yes comes only one time
3. Maximum time continues yes comes is 5
Please provide the VBA code or any formula for the above three point