How can I eliminate rows that contain the same data as the row ab.

[mjlucas49]

How can I compare rows in Excel aand eliminate those rows that have duplicate
information in them?

 

[Peo Sjoblom]

Use data>filter>advanced filter, select unique records only

 

[smaruzzi]

Is there a built-in function providing the same functionalities of Advanced
filter providing the source list and the destination area for the
select-distinct process?

Thanks, Stefano