Hey all! I've been messing with this and can't seem to get the answer I'm needing. I have a sheet that contains questions, with ranking drop downs. I have a separate sheet which I would like to pull any questions ranked as "Needs Improvement". I can manage to pull one at a time using =('Audit Sheet'!A5:B512, Match("Needs Improvement",'Audit Sheet'!(C5:C512,0,2) However, to avoid duplicates I have to allow the cell selection to move down. So the next cell would start at A9:B512 as a selection.
Is there a way to search the entire sheet and return all unique values from column B if column C is ranked "Needs Improvement"?