# How to list all names tied for the highest value in Excel

Filter for every row equal to the maximum: `=FILTER(A2:A8,B2:B8=MAX(B2:B8))`. A normal lookup returns only the first.

**Excel:** `=FILTER(A2:A8,B2:B8=MAX(B2:B8))` (Excel 2021, 2024 and Microsoft 365)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D |
| --- | --- | --- | --- |
| Team | Points |  | Leaders |
| Owls | 42 |  |  |
| Foxes | 47 |  |  |
| Bears | 39 |  |  |
| Hawks | 47 |  |  |
| Otters | 44 |  |  |
| Wolves | 47 |  |  |
| Lynx | 41 |  |  |

Formula in D2: `=FILTER(A2:A8,B2:B8=MAX(B2:B8))`

Result (spills 3 × 1): Foxes; Hawks; Wolves

## How it works

MAX finds the top total, 47. `B2:B8=MAX(B2:B8)` is TRUE for every team on 47, and FILTER returns all of them: Foxes, Hawks and Wolves. INDEX/MATCH or XLOOKUP would stop at Foxes.

## Other ways

- `=TEXTJOIN(", ",TRUE,FILTER(A2:A8,B2:B8=MAX(B2:B8)))`: All the leaders in one cell, separated by commas. (One cell: "Foxes, Hawks, Wolves".)
- `=INDEX(A2:A8,MATCH(MAX(B2:B8),B2:B8,0))`: Shown for contrast: a lookup returns only the first team on 47. (Only Foxes.)

## Common mistakes

- Values that look tied may differ in the decimals, like 46.999 and 47. Round both sides: `ROUND(B2:B8,2)=ROUND(MAX(B2:B8),2)`.
- The cells below `D2` must stay empty for the list to spill.

## Questions

**How do I list the ties for the lowest value, like a golf score?**

Use MIN: `=FILTER(A2:A8,B2:B8=MIN(B2:B8))`.

**How do I count how many are tied?**

Use `=COUNTIF(B2:B8,MAX(B2:B8))`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/names-tied-for-highest