Tutorials

Web Development

Bootstrap CSS HTML JavaScript jQuery Node.js PHP React TypeScript

Programming

C C#C++Go Java Python Rust

Data and Databases

AI Foundations Cybersecurity Fundamentals Data Structures and Algorithms Data Visualisation Databases Excel Machine Learning NumPy Pandas SQL Statistics

Tools

Projects

Project: A Tiny Shell in C Project: Bank Account System Project: Library Management System Project: Portfolio Page Project: Quiz App in React Project: Sales Data Analysis Project: Server Log Analyser Project: To-Do REST API Project: URL Shortener Project: Word Counter in Four Languages

All tutorials ❯

Paths References

Practice

Try it editor Quizzes How To recipes Tools Glossary

Home › References › Excel Function Reference

❮ SORT UNIQUE ❯

FILTER

Returns only the rows that meet a condition.

Group: Dynamic arrays

Syntax

FILTER(range, condition, [if_empty])

Example

Exampleexcel

Open in editor »

← All of Excel Function Reference