4,450 views
We talked about how to use the magic FILTER function in a simplified way, and its wonderful capabilities that make it a tool for filtering data quickly and effectively, and for organizing, filtering and analyzing data for one or more conditions, and how to display specific columns after filtering, as we talked about the following topics: 00:00 Introduction 00:20 Explaining the filter equation in its simple form 02:08 Applying the filter function when two or more conditions are met and 05:15 Applying the filter function when one of the conditions is met or 07:20 Getting a single column with a specific filter condition 08:43 Specifying specific columns to appear in the fitler equation table Download the work file: https://www.mediafire.com/file/sn3g7a... Previous related videos: INDEX AND MATCH equation in Excel Advanced search using Index and Match • INDEX AND MATCH equation in Excel The... Explanation of the IF function and its combination with the AND function to check the fulfillment of several conditions in the Excel program SI & ET • Explanation of the IF function and its combination with the AND function to check... A simple explanation of the IFS function, the best alternative to the compound IF function in Excel SI.CONDITIONS • A simple explanation of the IFS function, the best alternative to the... #Excel #FILTER_function #Data_filtering #Data_analysis #Excel_education #excel You can communicate via email: [email protected]