I mean, youre gonna be less likely to drop a bunch of creatures on the field if you know a board wipe could kill you, right
Forged in the fires of Oath of the Gatewatch expeditions
Creature - Human Rogue Color tag templates(None) Changeling Outcast Changeling (This card is every creature type.) This creature can't block and can't be blocked
It ignores the second IF function my current attempt is =INDEX(B:B,MATCH(LARGE(IF(D:D=Sector,IF(E:E=Sub Sector,F:F)),1),F:F,0)) where B:B = task name D:D = Sector names E:E = Sub Sector Names F:F = Priority Score V:V = Job Status (not above but required below) so ultimately what I want to be able to do is create a function that shows that if D:D has a specific name, and E:E also has a specific name, and V:V has names active, on hold OR unassigned then from the remaining list automatically on F:F search the top 3 scorers (or top scorer, 2nd, then 3rd by changing the parameter of large) and from which using xlookup/index.match to pull the task name from B:B so I mean, quite an easy one really I dont think Im asking for much thank you to anyone who even read all of that as I appreciate its a lot
At the time of Primeval Titans printing, the card Valakut, the Molten Pinnacle already existed