I have a long list of data imported to excel (around 4400 rows). The data is
financial, so there is heading row giving general supplier details, and then
subsequent rows giving specific invoice details for the supplier. Not every
supplier has invoice details so I want to remove from the list the suppliers
that don't have invoice details. As in:
Supplier Code Invoice number Description Total
ABC Limited ABC-1
Invoice 1234 Items $100
Invoice 1235 Items $100
XYZ Co. XYZ-1
PQR Co. PQR-1

so I would want to remove the lines for XYZ and PQR.

Many thanks

Aaron