Robert Germain
New Member
- Joined
- Mar 18, 2003
- Messages
- 11
Hi,
I've got two columns where I need to make sure that the order respects:
1 - The large value from column A5 to A10 (Total differential of runs scored)
2 - The large value from column T5 to T10 (Total points awarded for a win)
The issue that I see with the current Large(Array,k) is when the differential in points is negative, it doesn't seem to take into consideration that the points awarded for a team win, even-though it may be zero, that this team should be last as per the example below:
Col---TEAMS---Differential----Points
A5---Team_1-------10------------4
A6---Team_2--------4-------------2
A7---Team_3--------2-------------2
A8---Team_4------ -1-------------2
A9---Team_5------ -7-------------0
A10--Team_6------ -8------------2
I am thinking that this is a dual validation but I am not too sure how to go about this. Thanks for any leads on how to go about correcting this.
I've got two columns where I need to make sure that the order respects:
1 - The large value from column A5 to A10 (Total differential of runs scored)
2 - The large value from column T5 to T10 (Total points awarded for a win)
The issue that I see with the current Large(Array,k) is when the differential in points is negative, it doesn't seem to take into consideration that the points awarded for a team win, even-though it may be zero, that this team should be last as per the example below:
Col---TEAMS---Differential----Points
A5---Team_1-------10------------4
A6---Team_2--------4-------------2
A7---Team_3--------2-------------2
A8---Team_4------ -1-------------2
A9---Team_5------ -7-------------0
A10--Team_6------ -8------------2
I am thinking that this is a dual validation but I am not too sure how to go about this. Thanks for any leads on how to go about correcting this.
Last edited:
