Basically downloaded a list of customers from paypal.
One of the columns is for products, but there for every product there is a duplicate row beneath that just says ‘shopping cart’.
I would go through and delete each row seperately, but for 5000+ customers this seems incredibly lengthy and was hoping there was a way to do it all at once?
Cheers
If all rows to delete have “shopping cart” and only those have it.
Go to the top-left cell of data range or select the data range with their headers.
Menu/Data/Filter/Autofilter.
In the header with “shopping cart” field click the arrow and select only “shopping cart”.
Click on the top(row numbers)-left(column numbers) box, this select all rows an columns.
Click on the number of header row for deselect.
Right-click on any other row number and select delete rows.
Go again to the filter and select All.
Of course you can filter by other fields or use the Standard filter (with optional regular expression).
You can also mark column/s and select Data | Sort and it will sort the column and obviously group all of the ‘shopping cart’ together, so you can easily delete them.