1 name amount
2 Paul 200
3 John 100
4 Mary 250
5 Paul 100
6 John 300

After entering above data w/sheet should save this data like below
1 name amount
2 Paul 300
3 John 400
4 Mary 250

How to achieve this in Excel?

--
Message posted via http://www.officekb.com