Re: How do I remove duplicate fields in excel

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy


"Ivan Laars" <Ivan Laars@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:10F58F91-9761-4B3D-A3D5-BE633FA78237@xxxxxxxxxxxxxxxx
> Hello,
> I have a database where I need to strip out any instances where the text
> value of a cell is duplicated further down in the column. For instance, if
> cell c3 = "I hate you" and cell c200 = "I hate you", I want the second
> instance (and any others if there are more) to be deleted. Is there a
simple
> way to do this, or an established macro?
>
> Thanks,
> Ivan


.

Relevant Pages

  • Re: Value Property vs Text property
    ... Regards ... "Tom Ogilvy" wrote: ... >> I got a spreadsheet with comboboxs connected to a database. ...
    (microsoft.public.excel.programming)
  • Re: Summing the last records of every month.
    ... Regards, ... Tom Ogilvy ... > In a database table I have records which contain a date number and ... > I'm experimenting with array formulae, which I feel will be the ...
    (microsoft.public.excel.programming)
  • Re: Identify the column of a range by letter instead of number
    ... I'm testing it as a MSGBOX before I actually do my logic testing. ... "Tom Ogilvy" wrote: ... >> in my database, tell me how many cells have entries in them" ... >>> Regards, ...
    (microsoft.public.excel.programming)
  • Re: Jump to next line in box...
    ... Regards, ... Tom Ogilvy ... > I have a database of people, that when you search for one, it finds the ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Convert from WrapText
    ... Will try memo. ... Regards. ... > A record in Access or any other database is one row. ... >> the data in as close a manner as to that displayed in Excel, ...
    (microsoft.public.excel.programming)