| A | B | C | D | E | | Product code | Length | Width | Height | Weight |
I want to remove a row if all the values in that row are duplicates else where. Note that values in B, C, D and E may repeat elsewhere in the table, so conditional formatting doesn't help. I want to ensure the values in B, C, D and E are unique to each Product code in its row.
I would also like to delete rows that have the same Product code but have
0's in B, C, D and E.
Can anybody please point me in the right direction in what I need to look up on in order to achieve the above?