Formula to autofill certain values in a table from another tab with certain criteria?

[cjfwildcat]

Hello,

I have a fantasy draft this weekend and want to showcase my excel skills while building a draft kit. I have a tab set up with all of the draftable players. The columns include players name, team, projected points, etc... I have an additional column on that page where I input an "x" and it highlights the entire row, showing that I drafted that player.

I'd like to take that a step further and consolidate all of my drafted players into one tab. I need a formula that can look for all values in the column where I have the "x" and display them in a table on another tab.

I know how to do this with individual rows, but am unsure how I would do this with 16 different picks.

I could do it the long way and set up conditional formats to where I label each of my picks "1" through "16", instead of just an "x", but I'd rather have a simpler way of doing it.

Any ideas?

 

[bschwartz]

You can use a PivotTable and filter by the value X.