How to accomplish this

[tkraju via OfficeKB.com]

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?

 

[Pete_UK]

Debra Dalgleish shows how you can extract a unique list using Advanced
filter here:

http://www.contextures.com/xladvfilter01.html#FilterUR

The section below this shows how you can extract to another sheet. So,
supposing you have your unique list on another sheet in column A: in
B2 you can have this formula:

=SUMIF(Sheet1!A:A,A2,Sheet1!B:B)

and copy this down.

Hope this helps.

Pete

 

[מיכ×ל (מיקי) ×בידן]

If you would like to accomplish that with "pure" formulas [NO FILTERING] -
let us know.
Micky

 

[tkraju via OfficeKB.com]

Yes, with pure formulas.

If you would like to accomplish that with "pure" formulas [NO FILTERING] -
let us know.
Micky

1 name amount
2 Paul 200

[quoted text clipped - 10 lines]

How to achieve this in Excel?

 

[מיכ×ל (מיקי) ×בידן]

The INDEX Formula is an Array formula, and is to be confirmed with
CTRL+SHIFT+ENTER rather than with simply ENTER.
The curly brackets {} are not to be typed manually, those are entered by the
“Excelâ€, when the formula is entered as an Array formula.
Copy down the formulas until getting an Error
http://img690.imageshack.us/img690/2973/nonamet.png
Micky

Yes, with pure formulas.

If you would like to accomplish that with "pure" formulas [NO FILTERING] -
let us know.
Micky

1 name amount
2 Paul 200

[quoted text clipped - 10 lines]

How to achieve this in Excel?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/201003/1

.