relianceaaa
Board Regular
- Joined
- Jan 24, 2014
- Messages
- 76
Hello,
I have stumbled upon quite difficult task, maybe you could give me a hand at solving this task though.
SCORES OF STUDENTS
<tbody>
</tbody>
If H2 >2nd highest number result should be TRUE
1.If 2nd highest number is before 1st highest number ignore it and consider numbers which falls after 1st highest
(here Alan scored 70 marks which is 2nd highest. but it falls before 1st high = 90. consider 65 as 2nd highest and ignore 70 which was before 1st high score)
2.If 2nd highest falls immediately after 1st highest score, ignore that 2nd highest.
(Here Denver scored 90 which is 2nd highest but it falls immediately after 1st score. so consider 80 as 2nd highest)
3.If its a decrement value, dont consider any of the above values till we get an incremental value
(Here EZAN scred 95-90-80 but its in decremental series. so, 1st highest is 95 and 2nd highest is 51 and not 90 or 80)
4.Before 2nd highest number there should be a number which is lesser (Clive 2nd highest 70 . before that 60 which is lesser)
I really hope you can help.
Thank you
I have stumbled upon quite difficult task, maybe you could give me a hand at solving this task though.
SCORES OF STUDENTS
A1 | SCORE | SCORE | SCORE | SCORE | SCORE | SCORE | SCORE | RESULT |
ALAN | 50 | 60 | 70 | 90 | 50 | 65 | 60 | FALSE |
BORIS | 56 | 60 | 70 | 95 | 50 | 60 | 72 | TRUE |
CLIVE | 60 | 62 | 90 | 80 | 40 | 60 | 70 | TRUE |
DENVER | 50 | 100 | 90 | 70 | 60 | 80 | 77 | FALSE |
EZAN | 60 | 95 | 90 | 80 | 50 | 51 | 75 | TRUE |
<tbody>
</tbody>
If H2 >2nd highest number result should be TRUE
1.If 2nd highest number is before 1st highest number ignore it and consider numbers which falls after 1st highest
(here Alan scored 70 marks which is 2nd highest. but it falls before 1st high = 90. consider 65 as 2nd highest and ignore 70 which was before 1st high score)
2.If 2nd highest falls immediately after 1st highest score, ignore that 2nd highest.
(Here Denver scored 90 which is 2nd highest but it falls immediately after 1st score. so consider 80 as 2nd highest)
3.If its a decrement value, dont consider any of the above values till we get an incremental value
(Here EZAN scred 95-90-80 but its in decremental series. so, 1st highest is 95 and 2nd highest is 51 and not 90 or 80)
4.Before 2nd highest number there should be a number which is lesser (Clive 2nd highest 70 . before that 60 which is lesser)
I really hope you can help.
Thank you
Last edited: