+ Reply to Thread
Results 1 to 3 of 3

identify duplicated rows from a big list

  1. #1
    Registered User
    Join Date
    04-08-2008
    Posts
    5

    identify duplicated rows from a big list

    Hi everyone.
    How can i copy duplicated records from sheet1 to sheet 2 automaticaly. By formula.

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    You cannot "copy" by formula, you can display cell results or identify them, however you would have to copy the formula down for as many duplicates as you think you may have, when the source data changes then so will the results on sheet 2, the only way to find and copy all your duplicates is via code which then gives rise to other questions, do you want to show a duplicate and then a count of how many or just display the duplicates, would you want to delete the duplicates on the source sheet?, do you want to show the address of the duplicate?....just to name a few questions!
    Not all forums are the same - seek and you shall find

  3. #3
    Registered User
    Join Date
    04-08-2008
    Posts
    5

    to show duplicates and count

    Thank you very much. I want to select duplicated records and to separate them. If i can, copy duplicated record to new sheet, even may be their addresses.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1