Formula and Macro Needed
 

Hi, i want formula in column F cells that if "A1&B1&C1&D1" values come
together again in same row in any row of column (A:D) and if they have
Dr and Cr figures of same amount in same row in column E cells then
text "X" should appear elase "" . And then i need macro to delete all
text "X" rows.