I have 2 workbooks, One is a master listing of all store locations. The other shows locations that have purchased a particular item. How do I remove the stores that have purchased the item from the master listing?
In Master workbook:
1. Use VLOOKUP formula to identify Store Locations which are available in other workbook.
2. Apply filter uncheck option for #NA.
3. Select all visible rows and press Ctl + - to delete.