Returns a filtered version of the source range, returning only rows or columns that meet the specified conditions.
Examples
Make a copy
Filters a range using different conditions.
Sample Usage
FILTER[A2:B26, A2:A26 > 5, D2:D26 < 10]
FILTER[A2:C5, {TRUE; TRUE; FALSE; TRUE}]
FILTER[A2:B10, NOT[ISBLANK[A2:A10]]]
Syntax
FILTER[range, condition1, [condition2, ...]]
range
- The data to be filtered.condition1
- A column or row containing true or false values corresponding to the first column or row ofrange
, or an array formula evaluating to true or false.condition2 ...
- [ OPTIONAL ] - Additional rows or columns containing boolean valuesTRUE
orFALSE
indicating whether the corresponding row or column inrange
should pass throughFILTER[A2:C5, {TRUE; TRUE; FALSE; TRUE}]
1. Can also contain array formula expressions which evaluate to such rows or columns. All conditions must be of the same type [row or column]. Mixing row conditions and column conditions is not permitted.FILTER[A2:C5, {TRUE; TRUE; FALSE; TRUE}]
2 arguments must have exactly the same length asrange
.
Notes
FILTER[A2:C5, {TRUE; TRUE; FALSE; TRUE}]
1 can only be used to filter rows or columns at one time. In order to filter both rows and columns, use the return value of oneFILTER[A2:C5, {TRUE; TRUE; FALSE; TRUE}]
1 function asrange
in another.If
FILTER[A2:C5, {TRUE; TRUE; FALSE; TRUE}]
1 finds no values which satisfy the provided conditions,FILTER[A2:C5, {TRUE; TRUE; FALSE; TRUE}]
8 will be returned.
See Also
FILTER[A2:C5, {TRUE; TRUE; FALSE; TRUE}]
9: Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range.
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
„[…]there’s a real sense of togetherness and non-competitive authority about the playing, key features being Kim’s masterful and forthright yet elegant piano work, Gudrun’s blazing, beacon-like fiddling with its exemplary command of phrasing, and the relaxed chameleon-like instrumental talents of Hendrik and Jürgen – elements all faultlessly executed and brilliantly coordinated with a strong feel for complementary textures. At the same time, both Kim and Gudrun once again prove themselves to be outstanding song interpreters. You can’t lose with this band.“
: an ancient Indian possibly Barbacoan people of northern Ecuador conquered by the Incas in the 15th century
: the language of the Cara people
Love words?
You must — there are over 200,000 words in our free online dictionary, but you are looking for one that’s only in the Merriam-Webster Unabridged Dictionary.
Start your free trial today and get unlimited access to America's largest dictionary, with:
- More than 250,000 words that aren't in our free dictionary
- Expanded definitions, etymologies, and usage notes
- Advanced search features
- Ad free!
Subscribe to America's largest dictionary and get thousands more definitions and advanced search—ad free!
Whether a congregation is in the beginning of its journey, in mid-life or coming to fulfillment, its Archives is the heart and soul of the congregation’s memory. A congregation’s Archives is an invaluable resource, a treasury of stories documenting every facet of outreach and service that shaped the communities and dioceses in which the congregation lived and served.
Read More
Latest News
Special Report: Care of Elderly and Infirm Sisters among Catholic Sisters
Most research on Catholic sisters has focused on the role of lifestyle factors that support adults to age in a healthy way. There are a number of straightforward factors that contribute to Catholic sisters’ health, such as consistent nutrition and higher education. Catholic sisters’ positive health outcomes are also shaped by their cultural practices: how they pray, how they speak to each other, how they offer and receive social support, and how they understand what it means to be older in years. All of these cultural practices profoundly shape the sisters’ experiences of aging, pain, and the end of life.
Read More
Latest News
Photo by: George Martell, Roman Catholic Archdiocese of Boston
Young Adult Catholics Active in Faith Outside of Parishes
Six in ten Catholic young adults, ages 18 to 35, in the United States participate in a faith-related group outside of attending Mass at their parish. This result is from a recent national survey conducted by the Center for Applied Research in the Apostolate. The report and a presentation are available for review now.
Read More
We meet your research needs
Parishes | Dioceses | Religious Institutes | Catholic Media and Publishers | Catholic Schools | Catholic Colleges & Campus Ministries | National Organizations
CARA can help you with surveys, focus groups, interviews, demographics, mapping, planning studies, trend analysis, projections and forecasting, program reviews, market research, data collection and database creation and maintenance, archival research, and pre-test/post-test experiments.
CARA's team includes researchers and staff with degrees in sociology, political science, city planning, education, communications, business, marketing, philanthropic studies, religious studies, and church ministry. We're here to help you solve problems, understand issues, plan for the future, and be more effective.