Renaming data in a new column

[ebt]

Hello, I hope this is not too confusing: I am putting severa
spreadsheets together to use during my fantasy baseball draft. I'
creating a sheet for each team, and on each team's page I'm trying t
sort their draft results by position. I have a formula that can d
this, but in order to use it I need to uniquely identify each player'
position.


For example, if a team's first four picks are (Players in Column A o
the sheet, their respective positions in Column B)

Helton 1B
Pujols 1B, OF
Sexson 1B
Abreu OF


then I would like a column C to read the result from B, and if
contains a result that is equal to a position of an earlier drafte
player, then I would like a unique name in the new cell. That seem
extremely unclear, thanks so much for even reading this far, here's ho
I want column C to look in the example above:

1B
1B-2, OF
1B-3
OF-2

I think I could string some IFs and OR functions together in
simplistic fashion if there were only one or two positions involved
theproblem is that there are actually 9 different positions: C, 1B, 2B
3B, SS, OF, DH, SP, RP, and I want the second, third and fourth, etc
players at each such position to be labeled pos-2, pos-3, pos-4
respectively.

Thank you for any assistance you can provide, and if this is actuall
not possible in this format could you let me know that too

 

[CLR]

I'm not sure what to tell you because I don't really understand how to
determine who is #2, #3 etc at each position.........but I think I would
just concatenate the position in front of each name (1BHelton) in another
column and then just sort on that column and it would put each group
together and alphabetized........then just type in the numbers or do a fill
function............

hth
Vaya con Dios,
Chuck, CABGx3