Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mjlucas49
 
Posts: n/a
Default 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?
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default 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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 07:11 PM
flexible paste rows function that inserts the right number of rows marika1981 Excel Discussion (Misc queries) 1 February 18th 05 02:40 AM
Row selections by row # OR by even/odd rows in another spreadsheet Tom Excel Discussion (Misc queries) 0 February 9th 05 04:03 PM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 10:56 PM
Copying Rows when hiding other rows Neutron1871 Excel Worksheet Functions 2 November 3rd 04 11:38 PM


All times are GMT +1. The time now is 01:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"