Remove rows based on condition

[bwisealiahmad]

Hi,

I am trying to remove some rows from a phone log. The issue is that when they call from a phone central it logs both on main number and the actual number that that they are calling from. In this case I want to remove the rows with "+4767128800" but keep the row for 8834.

When these duplicates happen the RecNr, Time, LengthOfCall and Direction is always the same.

[bwisealiahmad]

Ended up doing it a different way, but this also is a good solution.

Thanks like always Sunny. Great reply