Copying cells with certain data next to it.

**multimediocrity** · 08-20-2009, 05:49 PM

I have two columns. I want to select everything in one column that has a certain value in the adjacent column.

Allow me to exemplify:

Code:

Col1  Col2
A     tree
B     eraser
B     bush
A     garden
A     tool
B     mesh
A     ball

Let's say I want to select all cells in Col2 which correspond to an A in Col1. Therefore, I want to select: tree, garden, tool, and ball. I want to copy these cells into a third column.

How would I do this?
I'm sure this is simple for experienced users. I am bested by my inexperience.

Thanks,
Multi

**NBVC** · 08-20-2009, 05:51 PM

=if(A1="A",B1,"") copied down

where A1 and B1 are first cells to look at.

**Cheeky Charlie** · 08-20-2009, 05:52 PM

lol @ exemplify - what?

anyway, select the headers of columns 1 & 2, then press Alt+d, then F, then F again
now click the arrow next to the top of column 1 and select "A" from the drop down.
Copy all of column B, it will only take the bits you need, and paste onto column C, now go back to column A and select "show all"

It's called autofilter and it's very handy...

HTH

**multimediocrity** · 08-20-2009, 05:53 PM

MAN you guys are FAST!!!
Geez, I barely had time to reload my browser before I got an answer.

Thanks a lot!

**multimediocrity** · 08-20-2009, 05:55 PM

And in the time it took to write that last response, I got ANOTHER response. Thanks!

**multimediocrity** · 08-20-2009, 05:57 PM

lol @ exemplify - what?

In consultation of Merriam-Webster:
Exemplify - to show or illustrate by example <anecdotes exemplifying those virtues>

Sorry, I felt the need to tread the infrequently visited areas of my lexicon.