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