Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Copy List Without Duplications

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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, 20:09.

  • #2
    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, 08:56.
    Kris

    ExcelFox

    Comment


    • #3
      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.

      Comment


      • #4
        Re: Copy Data Without Duplications

        Start Advanced Filter while on your destination worksheet.

        Comment


        • #5
          Re: Copy Data Without Duplications

          Thanks Dave.

          Comment

          Trending

          Collapse

          There are no results that meet this criteria.

          Working...
          X