Calculating of 1st and 2nd higher values

[oulyas]

Dear all,

I am calculating the first highest value as an output followed by the 2nd highest value.
Some of the results are not correct.

Example of the correct formula output

Here are the 3 soccer outcomes: 1 X 2


1 X 2

1 5 2 ----> the formula gives the 1st highest value X and the 2nd highest value 2 ( this is correct)


Example of the wrong formula output:

1 X 2
2 2 1 ----> the formula gives the 1st highest value 1 and the 2nd highest value 1 ( this is not correct, the correct output is 1 X or X 1)


If 2 highest values are equal , the formula should give as output both
Example:

1 X 2
5 0 0

Looking for a formula to give as an output for this example: 1st highest value 1 and for the 2nd highest value X2 or 2X

Please refer to the attched excel file, those listed examples are in, i hope i did not miss any detail, please let me know if you will require more information, i will deliver, thanks in advance for your support on that.

Regards
Oulyas

[AliGW]

Are you still using Excel 2013 or have you updgraded to 365?

[oulyas]

Dear AliGW, i am using Excel 2013.

[AliGW]

Thank you for clarifying.