 Don't manually copy and paste data that you need to filter and sort in Excel. Instead use this simple formula. Equals choose Coles, Open Bracket and the word Filter followed by another Open Bracket. Then select the range of data you need to filter. Select the range containing the data you need to filter. Then using my example do a greater than symbol and select the cell reference containing the value. We now need to select the columns from our data we wish to return. So for me the first one is going to be column 1 followed by column 4, closed brackets and you now have a dynamic formula that will update as you change your filter criteria. Don't forget to like and subscribe for even more videos.