The question says the Rank is calculated using the RANK function, so it's gotta be the sub-categories that have a rank value. I'm going with A, B, and C. No, wait, that's not it. Let me think this through again.
Ooh, this is a tricky one! I'm going to go with C, E, and G. Wait, did I just pick the wrong answer on purpose to be a rebel? Nah, that can't be right, I need to focus.
Hmm, let's see. If we're filtering out the sub-category where [Overall Rank] - 1, then the Rank value would change for the sub-categories that are affected by that filter. I think the correct answer is B, D, and H.
Vincent
3 days agoVincenza
10 days agoTaryn
12 days agoAlaine
13 days agoMarquetta
14 days agoDominque
20 days ago