Link to home
Avatar of MilesLogan
MilesLoganFlag for United States of America

asked on

remove items from a excel column

HI EE

I have 1000 lines in column A and have 100 lines in column B
I need to remove the 100 items in column B , from column A

Any ideas ?
Avatar of aikimark
aikimark
Flag of United States of America image

Will there be multiple columnB values in columnA?

You should be able to use columnB as a criteria range as long as they have the same column header.  Apply an advanced filter (In-place) and then delete the visible columnA cells (with shift-up)
Avatar of MilesLogan

ASKER

No --- >Will there be multiple columnB values in columnA?

Can you give me a more detail walk through or a link on this ?

You should be able to use columnB as a criteria range as long as they have the same column header.  Apply an advanced filter (In-place) and then delete the visible columnA cells (with shift-up)
Advanced filter should be close to the regular filter menu/ribbon item.  There needs to be the same column header value at the top of colA and colB.  The dialog is simple enough.
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Thank you both !