Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Copy List Without Duplications

  1. #1
    Join Date
    9th June 2004
    Location
    England
    Posts
    1,047

    Copy List Without Duplications

    On Worksheet Data 1 Column I there is a column of data with "some" duplicated text entries.

    The data is sorted so that all of the duplications appear in a blocks, i.e.

    This is the first
    This is the first
    This is the first
    This is the second
    This is the second
    This is the third
    This is the third
    This is the third
    This is the third
    This is the fourth
    This is the fifth

    I want to -
    Starting in Worksheet Data1 cell I4
    Copy A4 to Worksheet Data2 cell A4

    Then go back to Worksheet Data1 cell I4 drop down to cell I5 and if the data is the same as the data just copied drop down a cell and keep going until it reaches a cell with different non duplicated data.

    Then Copy that cell to Worksheet Data2 cell A5

    So that I end up with a list of data with no duplications.
    Last edited by Timbo; November 16th, 2006 at 20:09.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,678

    Re: Copy Data Without Duplications

    Hi,

    Select A4 on Data2

    go to Data > Filter > Advanced Filter

    check copy to another location

    listrange: Data1!$I$4:$I$1000

    copy to: Data2!$A$4

    check unique records only

    OK

    HTH
    Last edited by Dave Hawley; November 17th, 2006 at 08:56.

  3. #3
    Join Date
    9th June 2004
    Location
    England
    Posts
    1,047

    Re: Copy Data Without Duplications

    Hi Kris,

    I get a message you can only copied filtered data to the active sheet.

    I tried Autofilter first but that didn't work.

    I am just copying text nothing else.

    Tim.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,798

  5. #5
    Join Date
    9th June 2004
    Location
    England
    Posts
    1,047

    Re: Copy Data Without Duplications

    Thanks Dave.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Count Of Duplications
    By ayazgreat in forum Excel General
    Replies: 7
    Last Post: November 20th, 2007, 17:24
  2. Copy Sheet Rename With A List
    By cheapseats in forum Excel General
    Replies: 3
    Last Post: February 21st, 2007, 13:25
  3. Search List, Copy To Another Sheet
    By sarahann4883 in forum Excel General
    Replies: 1
    Last Post: December 19th, 2006, 19:29
  4. List Copy with an extra row between items
    By Rweasel6 in forum Excel General
    Replies: 5
    Last Post: March 7th, 2006, 04:25
  5. Copy Sheet and name from list
    By robinsma in forum Excel General
    Replies: 2
    Last Post: May 1st, 2005, 13:29

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
  •  
porno