# Find the highest 2 numbers from the cells.

#### asyamonique

##### Well-known Member
Hello Good Day,
I need a formula wich will show the highest 2 numbers in related cell ranges as given sample below.
Thank you.

 32 67.000 65 65.000 43 45 67 23

<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>
</tbody>

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Excel 2013/2016
ABC
132.00067.000
265.00065.000
343.000
445.000
567.000
623.000
Sheet3
Cell Formulas
RangeFormula
C1=LARGE(A1:A6,ROWS(\$1:1))

Let's replace 23.000 with 67.000. What would be the 2 results?

 67 67

<colgroup><col style="mso-width-source:userset;mso-width-alt:5339;width:110pt" width="146"> </colgroup><tbody>
</tbody>

Both cells gave the same results

Is that what you want as they are the two largest values, or do you still want it to show 67 & 65?

 67 67

<colgroup><col style="mso-width-source:userset;mso-width-alt:5339;width:110pt" width="146"> </colgroup><tbody>
</tbody>

Both cells gave the same results

What I was hinting at is: the results are then 67.000 and 67.000 or 67.000 and 65.000?

Highest two numbers from a column.

Hi,
Code:
``=LARGE([COLOR=Blue]A1:A6,ROWS([COLOR=Red]\$1:1[/COLOR])[/COLOR])``
That formula is ok,
Thanks again.

Last edited:
You're welcome & thanks for the feedback

Replies
1
Views
586
Replies
4
Views
758
Replies
10
Views
2K
Replies
4
Views
674
Replies
12
Views
1K

1,203,241
Messages
6,054,321
Members
444,717
Latest member
melindanegron

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back