Prev: I learn that way
Next: VBA//Oracle Interfacing Question
From: 1plane on 15 Nov 2009 20:42
On Nov 16, 1:18 am, OssieMac <Ossie...(a)discussions.microsoft.com>
wrote:
> Before automating the process with code, please confirm the following.
>
> When you refer to duplicates, am I correct in assuming that you mean
> duplicate amounts of money; not full duplicate records because as full
> records there are no duplicates in your example. If so, then you can do this
> with the following without code. If it returns the correct result and you
> still want the code to automate the process then let me know.
>
> Ensure you backup your data first in case this method does not return the
> expected result.
>
> Assuming that the C1, C2 etc is part of your data in column A then the money
> column will be column E.
>
> In the first empty column out to the right (say column G) insert the
> following formula in row 2 (I am assuming that you have column headers in row
> 1).
>
> =COUNTIF($E:$E,E2)
>
> Copy the formula down.
>
> Apply AutoFilter to the range of data.
>
> Set the filter for column G (the one with the above formula) to 1.
>
> Select all of the data BELOW the column headers.
>
> Select Edit -> Goto -> Special cells -> Visible Cells Only.
>
> Right click over the selected area.
>
> Select Delete rows. (At popup answer Yes to delete entire rows)
>
> Reset filter on column G to all data.
>
> --
> Regards,
>
> OssieMac

Hi OssieMac,

Is it possible to have a formula that compares the dates as well. i.e.
Row C1 and C2 dates and amounts must be the same.

Regards

1plane
From: OssieMac on 15 Nov 2009 20:57
Now you have stipulated "extract only rows with same day and amount", the
answer I gave will not work. However, before doing any more, what version of
xl are you using?

--
Regards,

OssieMac


From: 1plane on 15 Nov 2009 21:22
On Nov 16, 1:57 am, OssieMac <Ossie...(a)discussions.microsoft.com>
wrote:
> Now you have stipulated "extract only rows with same day and amount", the
> answer I gave will not work. However, before doing any more, what version of
> xl are you using?
>
> --
> Regards,
>
> OssieMac

I am using excel 2000.

Thanks once again.

Regards

1plane
From: OssieMac on 15 Nov 2009 21:37
Back to my previous question. What version of excel are you using? Makes a
difference as to how it can be done.

--
Regards,

OssieMac

From: 1plane on 15 Nov 2009 22:02
On Nov 16, 2:37 am, OssieMac <Ossie...(a)discussions.microsoft.com>
wrote:
> Back to my previous question. What version of excel are you using? Makes a
> difference as to how it can be done.
>
> --
> Regards,
>
> OssieMac

Hi OssieMac,

It is 9.0.3821 SR1.

Regards

1plane
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: I learn that way
Next: VBA//Oracle Interfacing Question