Thread: Deleting values in one file based on another file
View Single Post
 
Old 07-07-2024, 08:37 AM
RRB's Avatar
RRB RRB is offline Windows 11 Office 2021
Susan Flamingo
  
Join Date: May 2014
Location: The Holy City of Jerusalem
Posts: 302
RRB is on a distinguished road
Default Deleting values in one file based on another file
Hi dear Friends!

Is there an easy way, that even a total-excel-idiot like myself can handle for:

file (or worksheet1) column 1

a1
a2
a3
a4

file (or worksheet2) column 1

a1
a2
a3
a4
a5
a6
a7

Run the function and now file (or worksheet) 2 looks like this:

a5
a6
a7

I tried asking Google and did not see anything I could understand

Thank you and have a good day!

Susan Flamingo
Reply With Quote