I am trying to find first highest number and second highest number in excel. What shall i do for that. I did not find the right formula.

Note: I have already used the large and max formula.

```
=LARGE(E4:E9;1)
```

edit: guys I know if i write 2 instead of 1 i will get the result but i have to click the mouse to see all result.

This question is related to
`excel`

`worksheet-function`

If you want the second highest number you can use

`=LARGE(E4:E9;2)`

although that doesn't account for duplicates so you could get the same result as the Max

If you want the largest number that is smaller than the maximum number you can use this version

`=LARGE(E4:E9;COUNTIF(E4:E9;MAX(E4:E9))+1)`

- Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support
- Converting unix time into date-time via excel
- How to increment a letter N times per iteration and store in an array?
- 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)
- How to import an Excel file into SQL Server?
- Copy filtered data to another sheet using VBA
- Better way to find last used row
- Could pandas use column as index?
- Check if a value is in an array or not with Excel VBA
- How to sort dates from Oldest to Newest in Excel?
- Creating an Array from a Range in VBA
- Excel: macro to export worksheet as CSV file without leaving my current Excel sheet
- VBA: Convert Text to Number
- EPPlus - Read Excel Table
- How to label scatterplot points by name?
- What's the difference between "end" and "exit sub" in VBA?
- Rename Excel Sheet with VBA Macro
- Extract Data from PDF and Add to Worksheet
- Quicker way to get all unique values of a column in VBA?
- Multiple conditions in an IF statement in Excel VBA
- How to find and replace with regex in excel
- Unprotect workbook without password
- Excel is not updating cells, options > formula > workbook calculation set to automatic
- Find row number of matching value
- If "0" then leave the cell blank
- Clear contents and formatting of an Excel cell with a single command
- Remove Duplicates from range of cells in excel vba
- Delete worksheet in Excel using VBA
- Get list of Excel files in a folder using VBA
- Excel doesn't update value unless I hit Enter
- Declare a variable as Decimal
- Parse XLSX with Node and create json
- Detect if a Form Control option button is selected in VBA
- Get length of array?
- Object of class stdClass could not be converted to string - laravel
- Java - Writing strings to a CSV file
- Quickest way to clear all sheet contents VBA
- VBA: Counting rows in a table (list object)
- Excel VBA If cell.Value =... then
- VBA Excel - Insert row below with same format including borders and frames
- excel - if cell is not blank, then do IF statement
- filter out multiple criteria using excel vba
- Referencing value in a closed Excel workbook using INDIRECT?
- Use Excel VBA to click on a button in Internet Explorer, when the button has no "name" associated
- IndexError: too many indices for array
- File name without extension name VBA
- (Excel) Conditional Formatting based on Adjacent Cell Value
- Easy way to export multiple data.frame to multiple Excel worksheets
- Using ExcelDataReader to read Excel data starting from a particular cell
- What are the RGB codes for the Conditional Formatting 'Styles' in Excel?
- [Move to How to find the first and second maximum number?]

- WorksheetFunction.CountA - not working post upgrade to Office 2010
- Excel formula to get cell color
- How to find the first and second maximum number?
- IF statement: how to leave cell blank if condition is false ("" does not work)
- Use string value from a cell to access worksheet of same name
- I want to compare two lists in different worksheets in Excel to locate any duplicates
- Converting a string to a date in a cell
- Refer to a cell in another worksheet by referencing the current worksheet's name?
- Have Excel formulas that return 0, make the result blank
- Convert date field into text in Excel
- Get the last non-empty cell in a column in Google Sheets
- How to show current user name in a cell?
- Filter an array using a formula (without VBA)
- Concatenating date with a string in Excel
- Self-reference for cell, column and row in worksheet functions
- Compare data of two Excel Columns A & B, and show data of Column A that do not exist in B
- How to import data from one sheet to another
- Case Function Equivalent in Excel
- Last non-empty cell in a column
- How do I get the last character of a string using an Excel function?
- Excel function to get first word from sentence in other cell
- Get values from other sheet using VBA
- `IF` statement with 3 possible answers each based on 3 different ranges
- [Move to How to find the first and second maximum number?]