How do I find the top 3 values in Excel?

Answer 1

You need the LARGE function

For example, in column A:

Data

1

6

9

5

2

7

8

3

4

So the data lives in cell range A2:A10

Next Highlight Cells D2:D4

The array formula you need to input in the FORMULA BAR is

{=LARGE(A2:A10,{1;2;3})}

Note that you will need to hold down CONTROL-SHIFT before pressing ENTER, so

that the formula is applied to the entire ARRAY