asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,286
- Office Version
- 2013
- Platform
- Windows
Hello Good Day,
I need a formula wich will show the highest 2 numbers in related cell ranges as given sample below.
Thank you.
<colgroup><col style="mso-width-source:userset;mso-width-alt:3108;width:64pt" width="85"> <col style="mso-width-source:userset;mso-width-alt:1682;width:35pt" width="46"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> </colgroup><tbody>
[TD="class: xl66, width: 85"]32.000 [/TD]
[TD="class: xl65, width: 46"][/TD]
[TD="class: xl66, width: 68"]67.000 [/TD]
[TD="class: xl66"]65.000 [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]65.000 [/TD]
[TD="class: xl66"]43.000 [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]45.000 [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]67.000 [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]23.000 [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
</tbody>
I need a formula wich will show the highest 2 numbers in related cell ranges as given sample below.
Thank you.
<colgroup><col style="mso-width-source:userset;mso-width-alt:3108;width:64pt" width="85"> <col style="mso-width-source:userset;mso-width-alt:1682;width:35pt" width="46"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> </colgroup><tbody>
[TD="class: xl66, width: 85"]32.000 [/TD]
[TD="class: xl65, width: 46"][/TD]
[TD="class: xl66, width: 68"]67.000 [/TD]
[TD="class: xl66"]65.000 [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]65.000 [/TD]
[TD="class: xl66"]43.000 [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]45.000 [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]67.000 [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"]23.000 [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
</tbody>