Hi,

Add a few spare rows on your Map Data sheet and create three criteria ranges using the column label 'Max for each one and the column labels x & y in each of columns A & B, C & D and E & F. on say row 5.

e.g. In A1 Max and in A2 "Failed"

Then use the Raid Info columns D, E & F as your Advanced data filter input range, and A1:A2 as the criteria table and A5:B5 as one of the extract ranges. Repeat for the criteria and output ranges for Low Resources and Good Raids.