In many cases we may want to find the maximum values that satisfy one or more conditions of a**overcome**Record. There are many**overcome**Functions to complete the task. In this article, I will show you how to get to the top.**10**Values by criteria in**overcome**com**2**ideal examples. In addition, I also show the procedure to find the maximum values without specific criteria.

**Index** to hide

download exercise book

2 ideal examples to obtain the 10 best values according to criteria

1. Find the top 10 values based on a single criteria in Excel

1.1 Insert combination of BIG, IF and ROW functions

1.2 Apply the XLOOKUP, LARGE, and FILTER functions together

1.3 Using the INDEX-MATCH combination

2. Get Top 10 Values Based on Multiple Criteria in Excel

More examples of how to find the top 10 values in Excel

4. Use the INDEX and MATCH functions to find names that contain the top 10 values

How to identify the top 10 values with duplicates in Excel

Diploma

Related Posts

## download exercise book

You can download the workbook here.

**Top 10 Values by Criteria.xlsx**

## 2 ideal examples to obtain the 10 best values according to criteria

In this section, I'll show you how to get to the top.**10**Criteria-based values with**2**ideal examples. One deals with individual criteria, the other with multiple criteria. For the demonstration I used a data set with some students.**Name**, sign of**Physically**,**Chemical**mi**History**.

### 1. Find the top 10 values based on a single criteria in Excel

We can find the top**10**Values based on a single criteria using different functions and their combinations. I show below 3 ways to calculate the peak.**10**Values with unique criteria.

#### 1.1 Insert combination of BIG, IF and ROW functions

Let's follow the step by step procedure given below on how to use it.GROSS,SEmiLINEwork hard to get to the top**10**Values according to clear criteria.

- choose first
**cell G6**and write the following formula there.

`=BRUTO(SE(D6:D20>60,C6:C20,""),LINHA(A1:A10))`

- then press
**Tap**. - One by one we will see the top
**10**traces of**physically**no cell range**G6:G15**.

in the formula

**LINE (A1:A10)**This part creates an array of numbers.**1**for**10**.- MI,
**SE(D6:D20>60, C6:C20''")**This part checks the status**D6:D20>60**, if the condition is met, is generated as a cell in the range of**C6:C20**, if the criteria are not met, an empty value is returned.

o**GROSS**The function takes the above parts as arguments and returns the output array consisting of top**10**Paya**Physically**.

**For more information, see:** How to get cell value by row and column in Excel VBA

#### 1.2 Apply the XLOOKUP, LARGE, and FILTER functions together

we can also useXVERWEIS,**GROSS**mi**FILTER **Functions together to determine the top**10**Values according to clear criteria. Let's follow the steps below.

- choose first
**cell G6**and write the following formula there.

`=BUSCARX(GRANDE(FILTRO(C6:C20,D6:D20>60),LINHA(A1:A10)),C6:C20,B6:B20)`

- so hit
**Tap**. - As a result we will see
**Name**the students who performed best**10**Paya**Physically**.

The formula contains

**GRANDE(FILTRO(C6:C20,D6:D20>60),LINHA(A1:A10))**which provides the lookup value for the**XVERWEIS**Characteristic. ISLAND**Filter**The inner function works like this**SE**Function.**C6:C20**and the**lookup_array**mi**B6:B20**and the**return_matrix**.

#### 1.3 Using the INDEX-MATCH combination

We can do the same task withThe indexmithe gameworks together I show the steps for the following procedures.

- choose first
**cell G6**and write the following formula there.

`=ÍNDICE(B6:B20,COINCIDIR(BRUTO(FILTRO(C6:C20,D6:D20>60),LÍNEA(A1:A10)),C6:C20,0),1)`

- then press
**Tap**. - in the end we will see them
**Name**of students who received**Top 10 grades in physics**.

in the formula

**LINE (A1:A10))**This part returns an array of**1**for**10**.**FILTRO(C6:C20,D6:D20>60)**This part checks the status**D6:D20>60**and leaves**C6:C20**.- o
**GROSS**The function takes the above parts as arguments and gives the output**10**Pay.

o**FIT**is in**INDEX**The function takes all of the above parts as arguments and returns the**Name**up accordingly**10**physics grades.

**For more information, see:** How to find the highest value in Excel column (4 methods)

### 2. Get Top 10 Values Based on Multiple Criteria in Excel

Instead of a criterion, we can find the top**10**Values that meet multiple criteria. For the procedures, please follow the steps below to get the best**10**Values based on multiple criteria in Excel.

- start with selection
**cell G6**and write the following formula there

`=GRANDE(SE((--D6:E20>60)*(--E6:E20>50),C6:C20,""),LINHA(A1:A10))`

- so hit
**Tap**. - One by one we will see the top
**10**Physics notes that meet the requirements (more than**50**brands in history and more than**60**marks in chemistry).

in the formula

**LINE (A1:A10)**This part creates an array of**1**for**10**.**SE((–D6:D20>60)*(–E6:E20>50),C6:C20””)**and this part checks the conditions and outputs the cell range**C6:C20**.

Finally, that**GROSS**The function takes the previous parts as arguments and returns the final result as an array.

**For more information, see:**How to find value in column with VBA in Excel (4 ways)

## More examples of how to find the top 10 values in Excel

Now I will show you some examples of how to find the best ones.**10**Numbers without criteria.

### 1. Use the BIG and ROW functions to get the top 10 numbers

Follow the given steps to use the**GROSS**is in**LINE**Features to get you to the top**10**Pay.

- choose first
**cell G6**and write the following formula there.

`= GROSS ($C$6:$C$20, LINES(A1:A10))`

- so hit
**Tap**. - One by one we will see the result one by one.

**Supervision:**TThe formula contains the**GROSS**is in**LINE**Functions that work as described in the previous methods.

**For more information, see:** How to Find Top 5 Values and Names in Excel (8 Useful Ways)

### 2. Apply the LARGE AND COLUMN functions to find the top 2 consecutive values

we can change that**LINE**function withthe column functionto get the best numbers in a row.

- choose first
**cell G6**and write the following formula there.

`=BRUTO($C6:$E6,COLUNA(A1:B1))`

- so hit
**Tap**. - So let's take a look at the top
**2**student numbers**Name**.

**Supervision:**TThe formula is very similar to the previous method except that it uses the**TO DIVIDE**function (works along the line) instead of function**LINE**Function.

### 3. Identify the top 10 numbers using the SORT and FILTER functions

Principal**10**You can find the numbers with theORGANIZEis in**FILTER**Function. To do this, let's follow the steps below.

- choose first
**cell G6**and write the following formula there.

`=ORDENAR(FILTRO(C6:C20,C6:C20>=GRANDE(C6:C20,10)),1,-1)`

- then press
**Tap**. - We immediately see a series of results.

in the formula

**FILTRO(C6:C20,C6:C20>=BRUTO(C6:C20,10))**This part finds the top numbers.- So he
**ORGANIZE**The function rearranges the numbers in descending order.

**For more information, see:**Find value in column and return value from another column in excel

### 4. Use the INDEX and MATCH functions to find names that contain the top 10 values

We can also find the respective names of the main numbers. we will use those**INDEX**is in**FIT**functions for procedures. Let's follow the steps.

- choose first
**cell G6**and write the following formula there.

`=ÍNDICE(B6:B20,VERGLEICH(BRUTO(C6:C20,LÍNEA(A1:A10)),C6:C20,0),1)`

- also beat
**Tap**. - One by one we will see the results.

in the formula

**B6:B20**is the reference number of**INDEX**Function.- Payment in advance,
**KORRESPONDENZ(BRUTO(C6:C20,LINEA(A1:A10)),C6:C20,0)**This part specifies the line number and**1**is the column number of the**INDEX**Function.

**For more information, see:** How to find the last occurrence of a value in a column in Excel (5 methods)

### 5. Use the XLOOKUP and LARGE functions to get the top 10 numbers

We can use those too**XVERWEIS**is in**GROSS**Features to get you to the top**10**Numbers without criteria. Follow the steps below for this method,

- choose first
**cell G6**and write the following formula there.

`=XVERWEIS(BRUTO(C6:C20,LINHA(A1:A10)),C6:C20,B6:B20)`

- then hit
**Tap**and we will see the result.

**Supervision:**The formula uses the**XVERWEIS**, o**GROSS**is in**LINE**functions We have already used them in the previous methods. These functions work similarly to find the top**10**Results.

**For more information, see:** How to find value in column in Excel (4 methods)

## How to identify the top 10 values with duplicates in Excel

Sometimes our data set may contain repeated values. If we want to find the top**10**Numbers without repetitions, follow the steps given.

- choose first
**cell G6**and write the following formula there.

`= LARGE (SINGLE (E6: E20), LINE (A1: A10))`

- so hit
**Tap**. - Finally we will see the results.

in the formula

**SINGLE (E6:E20)**This part finds the unique values.- Which in turn serves as an argument for the
**GROSS**Function.

## Diploma

We can find the top**10**Criteria-based numbers in various ways. In this article I showed**2**ideal examples that meet the top**10**Criteria-based numbers in**overcome**. If you have any questions or suggestions, please let us know by leaving a comment.

## Related Posts

- How to Find the Lowest Value in an Excel Column (6 Ways)
- Find the first occurrence of a value in a column in Excel (5 ways)