A cell selection question
 

Hi again everybody,
Does anyone know, if you have cells like this in two columns, if there's a
way to select the cells in the first column based on what's in the second
one, for example, select all the cells in the first column that have an A in
the second one? I eventually want to move the selected cells to another
sheet and alphabetize them, but all I need is how to select them so I can
copy them. Thanks!
Jezzica85

example A
example B
example C
aexample A

A cell selection question
 

Yes. Assuming that you put a header cell on top of each column, you can use
autofilter to select all the rows that have A or B or C in the second column.
--
Gary's Student


"jezzica85" wrote:

Hi again everybody,
Does anyone know, if you have cells like this in two columns, if there's a
way to select the cells in the first column based on what's in the second
one, for example, select all the cells in the first column that have an A in
the second one? I eventually want to move the selected cells to another
sheet and alphabetize them, but all I need is how to select them so I can
copy them. Thanks!
Jezzica85

example A
example B
example C
aexample A