shamjamali
New Member
- Joined
- Nov 25, 2017
- Messages
- 2
Hi everyone, new forum user here with some knowledge on vba and excel. This has been a great resource for me to use excel effectively and am hopeful if someone can help me with a long time problem of mine;
Format: Excel Online
Code: Excel Formula
I am trying to figure out a function that's simple to think but hard to implement. I have tried troubleshooting using various codes and combination from other sources to no result. The problem I am facing is a variation of this problem;
https://www.mrexcel.com/forum/excel...ment-false-check-next-row-true-condition.html
I am currently using the code provided there to use in my function but its not working.
This is my excel layout:
AS you can see, I want to sort out the wins from the losses in column C based on game score. So far I have found the code from the link above to work close to my desired result, but it only seemed to sort some of the 'wins' and even misread some 'losses' as 'wins', This is a tough one for me
<code>=
Update: So I have troubleshoot this thoroughly and it seems that it would not work at cells other than A1:E12...any ranges beyond this will not work properly or not work at all, the final result will end in the 'value-if-error' of the iferror function. I will need it to work at a different range other than A1:E12.
I have tried dissecting each formula to test and the problem seemed to stem from the "small" function and its nested functions. I am able to produce correct results in small scale tests, but as soon as I add nested functions, it will not work.
Looking for some pointers on what went wrong with this code.
<tbody>
[TD="class: votecell"][/TD]
[TD="class: postcell"]
[/TD]
</tbody>
Format: Excel Online
Code: Excel Formula
I am trying to figure out a function that's simple to think but hard to implement. I have tried troubleshooting using various codes and combination from other sources to no result. The problem I am facing is a variation of this problem;
https://www.mrexcel.com/forum/excel...ment-false-check-next-row-true-condition.html
I am currently using the code provided there to use in my function but its not working.
This is my excel layout:
HTML:
B C D
2 Score W/L Sort Wins
3 100 Win 50
4 200 Win 100
5 500 Win 100
6 400 Win 105
7 300 Win 130
8 40 Lose 140
9 50 Lose 200
10 200 Win 200
11 250 Win 200
12 105 Lose 250
13 550 Win 300
14 600 Win 300
15 700 Win 400
16 400 Win 400
17 300 Win 500
18 200 Win 550
19 100 Lose 600
20 140 Lose 700
21 130 Lose
22 20 Lose
AS you can see, I want to sort out the wins from the losses in column C based on game score. So far I have found the code from the link above to work close to my desired result, but it only seemed to sort some of the 'wins' and even misread some 'losses' as 'wins', This is a tough one for me
<code>=
Code:
IFERROR(INDEX(B$3:B$22,SMALL(IF(C$3:C$22="Win",ROW(B$3:B$22)-ROW(B$3)+1),ROW(B1))),"")
</code>
Update: So I have troubleshoot this thoroughly and it seems that it would not work at cells other than A1:E12...any ranges beyond this will not work properly or not work at all, the final result will end in the 'value-if-error' of the iferror function. I will need it to work at a different range other than A1:E12.
I have tried dissecting each formula to test and the problem seemed to stem from the "small" function and its nested functions. I am able to produce correct results in small scale tests, but as soon as I add nested functions, it will not work.
Looking for some pointers on what went wrong with this code.
<tbody>
[TD="class: votecell"][/TD]
[TD="class: postcell"]
[/TD]
</tbody>