Hello all,
I'm trying to take an arranged set of competitors and a) source their names uniquely into a one-column leaderboard, and b) display any entries associated into the contest that received honorable mention or were selected by our editors for other features.
I have a main contest title Column A, then:
B- 1st Winner Column
C - 2nd Winner
D- 3rd
E - 4th
Through numerous honorable mentions to Column J.
I was initially using =COUNTIF(ContestEntries!$B$2:$J$31, CELL("contents", A2)) where Contest Entries was the name of the Worksheet and there were 31 entrants in this fashion. This allowed me to use a manually Advanced Filtered list of names from this array and display how many Wins, Mentions, or other Features were associated with their name string.
Now I have interpolated the entry types in this fashion:
B- 1st Winner
C- entry type
D- 2nd winner
E- entry type
How should I best source the entry type and display them next to the entrants' names on another Worksheet?
I'm trying to take an arranged set of competitors and a) source their names uniquely into a one-column leaderboard, and b) display any entries associated into the contest that received honorable mention or were selected by our editors for other features.
I have a main contest title Column A, then:
B- 1st Winner Column
C - 2nd Winner
D- 3rd
E - 4th
Through numerous honorable mentions to Column J.
I was initially using =COUNTIF(ContestEntries!$B$2:$J$31, CELL("contents", A2)) where Contest Entries was the name of the Worksheet and there were 31 entrants in this fashion. This allowed me to use a manually Advanced Filtered list of names from this array and display how many Wins, Mentions, or other Features were associated with their name string.
Now I have interpolated the entry types in this fashion:
B- 1st Winner
C- entry type
D- 2nd winner
E- entry type
How should I best source the entry type and display them next to the entrants' names on another Worksheet?
