P
pkbro
Okay, I'm fairly certain that this is going to be an easy question t
answer, but I've tried looking up the answer--and to be fair, I don'
know what category to try to find it under.
What I'm doing is this: I'm building a spreadsheet for severa
little-league softball teams. I am entering each player, his or he
age, whether they are a "him" or a "her", and what position they play
I need the Spreadsheet to be fully searchable--or at least "sortable
(if "sortable" is a word).
What I want to be able to do is this: be able to sort the data based o
the child's age and what position they play.
The problem I'm having is this: several of the children play multipl
positions.
Let's say we have little Billy. Billy plays third baseman, and he's a
alternate pitcher. When I sort the data according to position, I'd lik
the following to happen. If I sort for pitchers, I want Billy's name t
come up, but if I sort for Third Basemen, I want his name to come u
too. How do I enter two different sets of data into the same column an
get excel to attach it to the same player without entering the playe
into the database twice
answer, but I've tried looking up the answer--and to be fair, I don'
know what category to try to find it under.
What I'm doing is this: I'm building a spreadsheet for severa
little-league softball teams. I am entering each player, his or he
age, whether they are a "him" or a "her", and what position they play
I need the Spreadsheet to be fully searchable--or at least "sortable
(if "sortable" is a word).
What I want to be able to do is this: be able to sort the data based o
the child's age and what position they play.
The problem I'm having is this: several of the children play multipl
positions.
Let's say we have little Billy. Billy plays third baseman, and he's a
alternate pitcher. When I sort the data according to position, I'd lik
the following to happen. If I sort for pitchers, I want Billy's name t
come up, but if I sort for Third Basemen, I want his name to come u
too. How do I enter two different sets of data into the same column an
get excel to attach it to the same player without entering the playe
into the database twice