![]() To have it done, we supply the expression B2:B13="C" to the include argument, which will produce a required Boolean array, with TRUE corresponding to "C" values. In Excel 2019, Excel 2016 and earlier versions, it is not supported.įor starters, let's discuss a couple of very simple cases just to gain more understanding how an Excel formula to filter data works.įrom the below data set, supposing you want to extract the records with a specific value in the Group, column, say group C. The FILTER function is only available in Excel for Microsoft 365 and Excel 2021. If_empty (optional) - the value to return when no entries meet the criteria.Its height (when data is in columns) or width (when data is in rows) must be equal to the that of the array argument. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |