I have been toying with the advanced filter to remove duplicates from my records, but I am having problems where if I have a customer number entered multiple times for a different date and payment received, it removes all but one record.
The data contains a customer number, date, amount, premium, ID and commission and more..

10234 12-May-08 £530.59 £530.59 8926534 £0.00
12345 14-May-08 £224.10 £466.16 8926534 £0.00
12345 14-May-08 £224.10 £466.16 8926534 £0.00
12345 19-May-08 £242.06 £0.00 8926534 £0.00
12345 19-May-08 £242.06 £0.00 8926534 £0.00
26456 14-May-08 £189.00 £189.00 8926534 £0.00
34567 15-May-08 £201.88 £201.88 8926534 £0.00
45678 15-May-08 £173.42 £173.42 8926534 £0.00
56789 19-May-08 £326.33 £326.33 8926534 £0.00

Using 12345 as an example, when I filter it removes all but one record for 12345. I need to see all payments received monthly bar those duplicates.

Please help!