On Nov 16, 1:18*am, OssieMac
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

OssieMac,

Yes it works, it works.

I can confirm that I am refering to duplicate money (you are right)

Can you pls help with automating the code?

Regards

1plane