W tym obszarze szczeglne emocje budz okazje sezonowe i loterie, czsto czone z programem lojalnociowym, gdzie punkty wymienia si na nagrody lub dodatkowe korzyci
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
(2022-06-10) If an effect copies an Adventure spell, that copy is exiled as it resolves
Four of a Kind How many copies of any given card should you put in your deck
The most hyperbolic example is Atraxa, Grand Unifier