See how I created a FILTER() function for Excel 2010 and older versions of Excel.

To utilize the filter function in older versions of Excel, navigate to the Data tab, then click on Filter in the Sort & Filter group. If your Excel lacks the filter formula, it may be due to the version you’re using, as the filter function is available in Excel 2010 and later versions. In Office 2016, if filtering is not accessible, you might need to check your data range or consult with your IT support for potential software issues. An alternative to the filter function in Office 2016 is the /”Sort & Filter/” option under the /”Data/” tab, which allows for similar data manipulation. To enable filters in Excel, ensure your data is organized in a tabular format with headers, then select the data range and click on the Filter button in the Sort & Filter group under the Data tab.

This is how you can us my FILTER90 function for old Excels.

=FILTER_XYNET(A6:D44,A6:A44,G7,/”=/”)

=FILTER_XYNET(A6:D44,C6:C44,G24,/”＞/”)

#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ

Please take the opportunity to connect and share this video with your friends and family if you find it useful.