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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I eliminate rows that contain the same data as the row ab. (https://www.excelbanter.com/excel-discussion-misc-queries/14875-how-can-i-eliminate-rows-contain-same-data-row-ab.html)

mjlucas49

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

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

Peo Sjoblom

Use datafilteradvanced filter, select unique records only

--

Regards,

Peo Sjoblom

"mjlucas49" wrote in message
...
How can I compare rows in Excel aand eliminate those rows that have
duplicate
information in them?

smaruzzi

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

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

"Peo Sjoblom" wrote:

Use datafilteradvanced filter, select unique records only

--

Regards,

Peo Sjoblom

"mjlucas49" wrote in message
...
How can I compare rows in Excel aand eliminate those rows that have
duplicate
information in them?

All times are GMT +1. The time now is 02:16 PM.