Forum Discussion
delete multiple rows in a spreadsheet based on one of the multiples
I have a spreadsheet with data on an organization's members. In the left column it shows their member number. There are duplicates of the same members because I have a row for each product code they ...
Have you tried inserting a pivot table?
You can also insert a Slicer in your table
You can also insert a Slicer in your table
- Hi cris_no_h,
Thanks for your reply. I have had a look at both of these and they don't quite do what I'd like. I want a way where I can filter or delete all rows with a member number than has a specific product code on one row. Everything I've tried so far allows me to filter or delete the row with the product code on but does not include all other rows with that member on.
So looking at the example, I want to delete all members with a product code beginning with L. So I can delete row 4 as member 57 has a L balance, but he'd sill be on the list elsewhere with different products.
Many thanks,
Beck
