The Excel FILTER function filters a range of data based on supplied criteria, and extracts matching records. (https://exceljet.net/excel-functions/...)
In this video shows the two methods in using filter function, a quick methods is using the Data tab and the other one is using the filter formula.
Version (Office 365) but it is closely similar to older version of MS OFFICE
Watch video Excel Filter Function (Two Methods) online, duration hours minute second in high quality that is uploaded to the channel iTech4u 27 March 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 19 times and liked it 3 visitors.