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" 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 ExcelNext: Simple EXCEL worksheet function