Populate a table with unique names only, VLookUp attributes

kidkayc

New Member
Joined
Jan 30, 2018
Messages
1
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?
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top