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 ?
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
Last Comment
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)
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
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.
SOLUTION
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.
ASKER
Thank you both !
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)