Pay in 4 interest-free payments of $7.24 Learn more
Ships within 48 hours · Estimated delivery Aug 21 - Aug 26
Transcendence Market Price: $5.24 We all know about alternate win condition cards, but how about alternate lose conditions
You Cannot Hide from Me Ongoing Scheme (An ongoing scheme remains face up until it's abandoned.) At the beginning of combat on your turn, up to one target creature gets +2/+2 and gains vigilance until end of turn
It's a great card, and anyone who had played with or against Prophet of Kruphix knows exactly how dominate it can prove at the kitchen table
Many of the writers on this site make a living exclusively by buying and selling Magic cards
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
