Avatar of MilesLogan
MilesLogan
Flag 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 ?
Microsoft ExcelPowershell

Avatar of undefined
Last Comment
MilesLogan

8/22/2022 - Mon
aikimark

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)
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)
aikimark

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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER CERTIFIED SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION 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
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Rob Henson

THIS SOLUTION 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
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
MilesLogan

ASKER
Thank you both !