How can I extract the first entries for each key in Excel from the following
4 columns ?
(i.e. the maximum value of cocatenated columns 1,2 &4  e.g. JohnSmith200).  I
already concatenated the first 2 columns as the key and SUMmed the "Values"
for each key to create the "Running total" column.  

key & key    Values Running total
john smith      100      200
john smith         50     100
john smith         50       50
john thomas     50        50
bob jones         10     110
bob jones       100     100

I want:
john smith      100      200
john smith        50        50
bob jones         10     110
("Value" column though shown here, is not needed)

Thanks in anticipation.