LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 138
Default Entire Row Duplicates

Hi, I have read the pages of excel duplicates and I can work out how to find
duplicate rows, however I only want to identify an entire row as a duplicate
if every
single cell from row a-q exactly matches, any ideas how I would do this? I
don't have 2007 excel so don't have the data delete duplicates option.

Many thanks for your advice.
Paula

 
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
Populate and entire row while removing duplicates. NightLord Excel Discussion (Misc queries) 2 September 25th 08 07:08 AM
Condensing a list with duplicates to a list with non-duplicates Nuclear Excel Worksheet Functions 2 July 29th 08 08:03 PM
Duplicates in excel that aren't 100% DUPLICATES ... [email protected] Excel Discussion (Misc queries) 4 May 2nd 08 06:43 PM
Don't allow duplicates Mark Excel Discussion (Misc queries) 2 September 12th 07 06:40 AM
Duplicates? Zip Codes Excel Discussion (Misc queries) 1 June 3rd 05 04:17 PM


All times are GMT +1. The time now is 10:00 AM.

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

About Us

"It's about Microsoft Excel"