Help w/ duplication

R

ricdik

I want to reference the cells below by Team and then by position. The
cells I want to reference are below.

Name-Team-Position-bye week-Drafted by
Aaron Elling-Vikings-K-4-Team 09
Adam Vinatieri-Patriots-K-3-Team 02
Alexander, Shaun-Seahawks-RB-4-Team 01
Alstott, Mike-Buccaneers-RB-8-Team 12
Anderson, Mike-Broncos-RB-10-Team 05
Anderson, Richie-Cowboys-RB-4-Team 01


I want them put in order like this...

Position-Player-Price-Bye
QB - Player - $XX -
QB - Player - $XX -
QB - Player - $XX -

RB - Player - $XX -
RB - Player - $XX -
RB - Player - $XX -
RB - Player - $XX -
RB - Player - $XX -
RB - Player - $XX -

WR - Player - $XX -
WR - Player - $XX -
WR - Player - $XX -
WR - Player - $XX -
WR - Player - $XX -
WR - Player - $XX -

K - Player - $XX -
K - Player - $XX -

DEF - Player - $XX -
DEF - Player - $XX -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count all but a specific reference cell (countif ?) + 3
Finding the weighted average of text that have been given values 1
Translating Formulas to Functions 0
Copy row data based on drop down list selection 0
Fantasy Football Conditional Arrays 4
Newbie question 2

Top