Re: Deleting Duplicates, All records unique

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


You are brilliant!!! Thank you so much! You saved my day and gave me
back hours of my life! Thank you thank you!

I am so appreciative!
Arielle

Pete Wrote:
> Here's another fairly quick way. I assume your data is not sorted by
> filename and I presume you want to keep the sequence you have at the
> moment. Assume your four fields occupy columns A to D, and that the
> data starts in row 2 (after the headings) and goes down to row 5000.
>
> Add the heading "seq" in column E and in E2 enter 1. Highlight cells
> E2
> to E5000 then Edit | Fill | Series and check Linear with a step value
> of 1. Click OK - this will fill a sequence down this column to enable
> you to get the data back into the same order.
>
> Highlight A1 to E5000 and sort the data using filename (column B). Add
> the heading "Check" in column F, and in cell F2 enter the following
> formula:
>
> =IF(OR(B2=B1,B2=B3),"duplicate","unique")
>
> Copy this down to F5000 (double-click the fill handle). Select Data |
> Filter | Autofilter (on). Filter column F for "duplicate". Highlight
> all visible rows between Row 1 and Row 5001, and Edit | Delete Row.
> Use
> the filter pull-down on column F to select "All", then Data | Filter |
> Autofilter (off).
>
> Re-sort the remaining data using column E (seq) for sort order.
> Finally, delete columns E and F.
>
> Hope this helps.
>
> Pete


--
mirdonamy
------------------------------------------------------------------------
mirdonamy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30348
View this thread: http://www.excelforum.com/showthread.php?threadid=500305

.

Relevant Pages

  • Re: Heres one problem
    ... On Sep 28, 9:19 pm, "Pete Dashwood" ... exact sequence of what they did is usually not productive. ... credibility - and we KNOW you are both competent programmers. ... I haven't yet downloaded your COBOL program to take a look, ...
    (comp.lang.cobol)
  • Re: Heres one problem
    ... On Sep 28, 9:19 pm, "Pete Dashwood" ... exact sequence of what they did is usually not productive. ... I don't even like writing it, but some others must have had the same thought; rushing the publication of a project that didn't totally work, smoothly, given the environment options, it brings into question your credibility - and we KNOW you are both competent programmers. ... So given your format, what percentage of COBOL programmers do you think actually give a picture of data items, WITHOUT a final period/full Stop? ...
    (comp.lang.cobol)
  • Re: My name being used.
    ... Hash: SHA256 ... automatically hides it while interpreting the sequence. ... extracting key information like passwords. ... Pete, here's a tip mate, make sure you include your PGP key on all the ...
    (uk.legal)
  • Re: Deleting Duplicates, All records unique
    ... filename and I presume you want to keep the sequence you have at the ... Click OK - this will fill a sequence down this column to enable ... Re-sort the remaining data using column E for sort order. ...
    (microsoft.public.excel.misc)
  • Re: Implementation-defined behaviour
    ... pete wrote: ... That's why I call it implementation-defined behaviour. ... It's unspecified behavior. ... This is all about sequence points. ...
    (comp.lang.c)