Hello,
I'm currently using an Advanced filter to search a spreadsheet for lottery results.
Each person has 4 numbers and have 3 lines with 4 numbers on each line.
I have attached the file.
What I'm trying to do is to filter for people who had 3 number from their 4. I set up the criteria range like below but it doesn't work 100%. The first time I tried it, it worked fine but then some options didn't work. Any help greatly appreciated.
Bookmarks