delete duplicate records after totaling a field from each record

Hello, I have a large amount of records in excel some of the records contain data on the same person, I need to taille up one of the fields from each of the duplicates and then delete the the duplicate records. Does this sound possible without VBA code anyone got any ideas on how to achieve this???

Thanks in advance. Harry

An idea may be you can put a formula in a free column (but you nedd data to be sorted by person name column).

For example, if you have person names in column A (from row '2' to 'n') you can use this formula from range A2 to A'n':
=SE(A2=A2; ""; A2)

and you will notice what is the first occurence of each name.
Now you can filter the column with the formula, select data with empty cell and delete all rows

Regards,
Antonio