Hi Emily,
Thanks for all the great tips. I went through each one to ensure my settings where the same and so far it seems that I have done everything correctly. Although clearly I haven’t because it is not working. When i put in my filter criteria as you suggested with the colon it only returns the results of the first search option. I have attached a picture of my results.
The box to the left is where I type in my invoice numbers. The table to the right is the data I am filtering.
