I have a spreadsheet, currently in a subtotalled format, of which under each
subtotal I need to be able to find a way of discounting duplicate entries.

Does anyone know of a way of doing this?

Any help gratefully appreciated.