Look things up
Show only the rows that match
=FILTER(A2:B5,B2:B5>100,"No matches")How it works in Excel
- A2:B5 is the table.
- B2:B5>100 is the test for each row.
- "No matches" shows if no row passes.
- Results flow into the cells below and to the right, so keep them empty.
- The result updates when your data changes.
- It needs Excel 2021 or Microsoft 365.
The idea in general
It pulls out only the rows you asked for and leaves the original list alone.
What I assumed
- Your table is in A2:B5 and you want values in column B above 100.
Check the result on your own data before relying on it.