 Are you still trying to filter your Excel data like this? Then try this formula instead, equals filter, and select the entire range containing your data. Next, select the range that requires a filter, and finally, select the cell reference containing your filter term. You now have a dynamic formula that will update in line with your search term. Don't forget to like and subscribe for even more videos.