Remove dups, combine cell total

Data in col A-U. Delete rows with duplicate policy numbers and total the S column for all.
Column B Column S
CF00034 -- 5.21
CF00034 -- 2.15
PE00011 -- 1.45
PE00011 -- 4.03
PE00011 -- 2.16
G000001 -- 5.25

output - - Need to keep all data for columns A-U but delete the duplicate records and total the S column (deleted record 2, 4 and 5 added their S column to the first one)
A..........B...........C.......D.......E.......S........T......U
01 - CF00034 - Jane - xxxx - xxx - 7.36 - xx - xx
01 - PE00011 - John - xxxx - xxx - 7.64 - xx - xx
01 - G000001 - Mike - xxxx - xxx - 5.25 - xx - xx

Try this.

Not that this is designed to build the summary in columns AA onwards and then deletes columns A to Z

Please Login or Register  to view this content.

Regards

Sorry, alternative approach but beaten to the punch ;-)

Having so much fun putting it together, you might as well have it.

Regards