A cell selection question

J

jezzica85

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
 
G

Gary''s Student

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.
 
Top