We have a large excel sheet that has something like this:
LINE: ORDER # ITEM
1 0001 iPhone
2 0001 Charger
3 0002 iPhone
4 0002 Charger
5 0002 Case
6 0003 Charger
7 0003 Case
8 0004 iPhone
9 0004 Charger
10 0004 Case
We need to find and delete all rows from orders that do not have "iPhone" in it. So for example, Order #001 is ok because there is iPhone in Line 1.
Order #002 is ok because there is iPhone in the order (Line #3)
Order #003 is BAD because nowhere in Order #003 is there an iPhone. There is only Charger (Line #6) and Case (Line #7). So we need to delete/clear Line #6 and Line #7 to remove Order #003.
Order #004 is ok because there is iPhone on Line #8
So we need someone to provide method, instructions, or formula to allow us to fix a spreadsheet that contains thousands of rows.
16 freelancer đang chào giá trung bình $24 cho công việc này
Hi, i am from Greece my name is [url removed, login to view] s clear what you need to keep orders with iphone in a line.i am able to do it no matter how many lines you have b using pivot table andthen [url removed, login to view] m Relevant Skills Thêm