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

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

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

On Mar 12, 5:38*pm, "tkraju via OfficeKB.com" <u16627@uwe wrote:
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 viahttp://www.officekb.com

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


"tkraju via OfficeKB.com" wrote:

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

.

Yes, with pure formulas.

מיכ�ל (מיקי) �בידן wrote:
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.a...excel/201003/1

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


"tkraju via OfficeKB.com" wrote:

Yes, with pure formulas.

מיכ�ל (מיקי) �בידן wrote:
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.a...excel/201003/1

.