Prev: how do I use color in drop down list in Excel
Next: Simple EXCEL worksheet function
From: tkraju via OfficeKB.com on 12 Mar 2010 12:38
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

From: Pete_UK on 12 Mar 2010 13:54
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

On Mar 12, 5:38 pm, "tkraju via OfficeKB.com" <u16627(a)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

From: מיכאל (מיקי) אבידן on 13 Mar 2010 09:12
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
>
> .
>
From: tkraju via OfficeKB.com on 13 Mar 2010 11:27
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.aspx/ms-excel/201003/1

From: מיכאל (מיקי) אבידן on 13 Mar 2010 13:17
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.aspx/ms-excel/201003/1
>
> .
>
 | 
Pages: 1
Prev: how do I use color in drop down list in Excel
Next: Simple EXCEL worksheet function