re: How to delete repeted rows automaticaly result

From: Mark (anonymous_at_discussions.microsoft.com)
Date: 11/27/04 

Date: Fri, 26 Nov 2004 17:48:28 -0800

Hi,
I wrote something recently for another user and the main
problem was that although I created each string in upper
case it does not take into account that one cell had ST
and the other cell had Street. You have to make sure that
rrepeated lines are actually repeats, word for word. Send
me your email and I will send it to you.

excelmarksway@yahoo.com.au

- -mark

see my excel stuff:
http://au.geocities.com/excelmarksway
http://www.geocities.com/excelmarksway

>-----Original Message-----
>
>Hello,
>
>I have a very big list of adresses and phones. There are
a lot of
>repeted data in it.
>I would like to know if there is a way to erase the
repeted rows of my
>list automaticaly. If it is possible, how can I do it?
>
>Thanks very much.
>
>Matheus
>
>
>--
>gabarrao
>----------------------------------------------------------
--------------
>gabarrao's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=16885
>View this thread:
http://www.excelforum.com/showthread.php?threadid=320598
>
>.
>

Relevant Pages

  • Re: ON.DOUBLECLICK function
    ... "...Typing the account number for each ... seems far more work then simply double clicking on a cell and have ... this sheet they can go back to the initial sheet..." ... Sub SetOnDoubleClick() ...
    (microsoft.public.excel.misc)
  • RE: Data Validation - select AcctName and AcctCodes shows
    ... Assuming your request is to have 7 other drop down lists based off different ... If, however, you are looking for more data based on the now account number, ... only works for the first cell. ... Dim Look2 As Variant ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Help with Macro that searches a Range for specified informatio
    ... I assumed your account number list was contiguous (no blank cells ... Dim rng as Range, cell as Range ... Dim OrigRow As Integer ...
    (microsoft.public.excel.programming)
  • Re: Have user input converted to uppercase in same cell as input?
    ... Either event code to change the text to UPPER as it is entered or a macro to ... operates on Columns A:H as you enter text in a cell. ... Set bigrange = rng2 ... Run the macro by going to Tool>Macro>Macros. ...
    (microsoft.public.excel.newusers)
  • Re: Excel: how to convert text to upper case upon entry?
    ... For Each Cell In Selection ... First...create a backup copy of your original workbook. ... hit ALT + F11 to open the Visual Basic Editor. ... be converted to upper case when I hit the Enter or Tab key? ...
    (microsoft.public.excel.misc)