You could insert a helper column, and then, assuming invoice number is in
column C...

=COUNTIF(C:C,C2)1

Filter the column for "TRUE" to find all your record that have duplicates.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Shon" wrote:

Is there a facility in Excel 2007 to KEEP duplicate records? I can find ways
of removing them through remove duplicates and advanced filtering but I want
to be able to retain duplicate records and remove all others based on
duplicate values in some of the columns e.g. if I have the following data

Customer Number Invoice Number City Reponsible Branch Amount
21500 1234 London LO14 £150
21500 1235 London LO12 £99
21500 1236 London LO13 £45
21500 1237 London LO14 £150
21600 1238 Glasgow GL56 £80
21600 1239 Glasgow GL57 £60
21600 1240 Glasgow GL56 £80
21700 1241 Leeds LE01 £50
21700 1242 Leeds LE02 £40
21700 1243 Leeds LE01 £50

I would expect to see the following result based on finding duplicate values
per record in the fields Customer number, City, reponsible branch and amount.

Customer Number Invoice Number City Reponsible Branch Amount
21500 1234 London LO14 £150
21500 1237 London LO14 £150
21600 1238 Glasgow GL56 £80
21600 1240 Glasgow GL56 £80
21700 1241 Leeds LE01 £50
21700 1243 Leeds LE01 £50