Compare 4 values in a row/column

[alexukgb]

Hi All,

could you please help in this issue.
I am trying to compare four columns
L1, L2 , L3, L4

compare the value in L2 or L3 or L4 if its different to the value in L1 cell then delete that row. if there is a blank cell in one or 2 of these cells then ignore the blank and compare next cell.

Thankx for your help and support.

[alexukgb]

L1 L2 L3 L4
9193 9193 9193 9193 don’t delete the row
9193 13196 13196 delete the row
9193 9193 9193 delete the row
9193 13196 13196 don’t delete the row
9193 11861 11861 don’t delete the row
9193 9193 9193 9193 delete the row
13196 13196 delete the row
11861 11861 11861 delete the row
9193 13196 don’t delete the row
9193 9193 delete the row
9193 13196 13196 don’t delete the row
9193 11861 11861 don’t delete the row
9193 9193 delete the row
21855 21855 21855 delete the row
21855 21855 delete the row
5528 26184 5528 26184 don’t delete the row
5528 30048 5528 30048 don’t delete the row

[alexukgb]

I have updated the test sheet.