Excel 97
I know I've seen the answer to this question somewhere but I can't seem to find it now.
Suppose I have a list of names of players and their teams, but the team is only listed for the first player of each team. How to I easily fill in the blanks. Example:<PRE>
Team Player
ANA Mike Holtz
Orlando Palmeiro
Mark Petkovsek
BAL Charles Johnson
BOS Carl Everett
Bryce Florie
Rich Garces
Scott Hatteberg
should be
ANA Mike Holtz
ANA Orlando Palmeiro
ANA Mark Petkovsek
BAL Charles Johnson
BOS Carl Everett
BOS Bryce Florie
BOS Rich Garces
BOS Scott Hatteberg</pre>
Thanks,
Cliff
This message was edited by baseball on 2002-10-23 08:29
I know I've seen the answer to this question somewhere but I can't seem to find it now.
Suppose I have a list of names of players and their teams, but the team is only listed for the first player of each team. How to I easily fill in the blanks. Example:<PRE>
Team Player
ANA Mike Holtz
Orlando Palmeiro
Mark Petkovsek
BAL Charles Johnson
BOS Carl Everett
Bryce Florie
Rich Garces
Scott Hatteberg
should be
ANA Mike Holtz
ANA Orlando Palmeiro
ANA Mark Petkovsek
BAL Charles Johnson
BOS Carl Everett
BOS Bryce Florie
BOS Rich Garces
BOS Scott Hatteberg</pre>
Thanks,
Cliff
This message was edited by baseball on 2002-10-23 08:29