Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links

Replace Duplicate Rows

Windows Software

Thread Tools Search this Thread
Old 20-07-2010
Join Date: Jul 2010
Posts: 1
sad Replace Duplicate Rows

I am new to macros and need some help. I have found numerous code for deleting all but the first instance of a duplicate row. However, I need something a little different. I have a table with about five columns of data. I need a macro that will search column 1 for duplicate entries and replace the first instance with the last one. Does anyone know if this is possible?

Reply With Quote
Old 20-07-2010
Join Date: Dec 2007
Posts: 2,295
Re: Replace Duplicate Rows

The formula below will display the words "Duplicates" or "No Duplicates" indicating whether there are duplicates elements in the list A2:A11.

=IF(MAX(COUNTIF(A2:A11,A2:A11))>1,"Duplicates","No Duplicates")

For more information go here.
Reply With Quote

  TechArena Community > Software > Windows Software
Tags: , , , ,

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads for: "Replace Duplicate Rows"
Thread Thread Starter Forum Replies Last Post
Delete duplicate rows using Macros Dyumani Windows Software 5 12-10-2011 11:30 AM
How to combine data in duplicate rows in MS excel Virginia Windows Software 7 10-07-2011 11:13 AM
How can I highlight duplicate rows of excel sheet with color? Sarfaraj Khan Windows Software 5 08-01-2010 10:15 AM
Merging duplicate names not rows copy rows into new workbook each time VBA Excel 2003 awkwardsmile Software Development 2 09-07-2009 08:57 AM
Need script to identify duplicate rows Dwij Software Development 4 30-06-2009 05:21 PM

All times are GMT +5.5. The time now is 01:43 PM.