|
|
|
Author |
Message |
apkolev
|
Posted: Wed May 23 18:20:34 CDT 2007 |
Top |
Excel >> Total Different Cells
I have a list of cells in two rows:
Harry 40
John 41
Harry 13
Bob 20
John 23
Bob 23
I need to extract the total of each person and enter in another TWO
rows by name and amount. Only one name for each person will appear.
As:
Harry 53
John 64
Bob 43
NOTE:--Alpha'd if possible.
Thanks.
Etc.
Excel391
|
|
|
|
|
Peo
|
Posted: Wed May 23 18:20:34 CDT 2007 |
Top |
Excel >> Total Different Cells
Select the name range (not the numbers) including a header, if there is no
header create one.
Then apply data>filter>advanced filter, select copy to another location and
unique records only. If you copy the filtered rang to let's say H1 you will
get a header in H1 and a unique name list below. No in I2 put
=SUMIF($A$2:$A$50,H2,$B$2:$B$50) (where A2 is the first cell with names in
your original list with names and numbers)
copy down as long as needed
--
Regards,
Peo Sjoblom
>I have a list of cells in two rows:
>
> Harry 40
> John 41
> Harry 13
> Bob 20
> John 23
> Bob 23
>
> I need to extract the total of each person and enter in another TWO
> rows by name and amount. Only one name for each person will appear.
>
> As:
> Harry 53
> John 64
> Bob 43
>
> NOTE:--Alpha'd if possible.
>
> Thanks.
>
> Etc.
>
|
|
|
|
|
Erny
|
Posted: Thu May 24 14:14:18 CDT 2007 |
Top |
Excel >> Total Different Cells
Hi,
Presuming the names are in the first column, and the amounts in the second,
and you wish for instance to have the aggregated data in the 4th and 5th
column:
First insert a title row on top of your data and specify for instance "Name"
on top of the first column and "Amount" on top of the second.
Select both columns, then Use >Data >Pivot Table, accept the range of the 2
columns, then specify that you wish to postion the results from cell D1
onwards (provided you don't have any data there, otherwise you could also
present the results in a different sheet.
Then, add the "Name" variable to the "row" area, and the "Amount" variable
to the "Data" area. As a result you will have the table you wish in a nice
format...
Hope this helps,
Erny
>I have a list of cells in two rows:
>
> Harry 40
> John 41
> Harry 13
> Bob 20
> John 23
> Bob 23
>
> I need to extract the total of each person and enter in another TWO
> rows by name and amount. Only one name for each person will appear.
>
> As:
> Harry 53
> John 64
> Bob 43
>
> NOTE:--Alpha'd if possible.
>
> Thanks.
>
> Etc.
>
|
|
|
|
|
Harry's
|
Posted: Mon May 28 09:02:33 CDT 2007 |
Top |
Excel >> Total Different Cells
On May 24, 1:14 pm, "Erny" <Erny-removehyphensandthistext-
> Hi,
>
> Presuming the names are in the first column, and the amounts in the second,
> and you wish for instance to have the aggregated data in the 4th and 5th
> column:
>
> First insert a title row on top of your data and specify for instance "Name"
> on top of the first column and "Amount" on top of the second.
> Select both columns, then Use >Data >Pivot Table, accept the range of the 2
> columns, then specify that you wish to postion the results from cell D1
> onwards (provided you don't have any data there, otherwise you could also
> present the results in adifferentsheet.
> Then, add the "Name" variable to the "row" area, and the "Amount" variable
> to the "Data" area. As a result you will have the table you wish in a nice
> format...
>
> Hope this helps,
> Erny
>
>
>
>
> >I have a list ofcellsin two rows:
>
> > Harry 40
> > John 41
> > Harry 13
> > Bob 20
> > John 23
> > Bob 23
>
> > I need to extract thetotalof each person and enter in another TWO
> > rows by name and amount. Only one name for each person will appear.
>
> > As:
> > Harry 53
> > John 64
> > Bob 43
>
> > NOTE:--Alpha'd if possible.
>
> > Thanks.
>
> > Etc.- Hide quoted text -
>
> - Show quoted text -
Thanks...it works. Now, I have to figure out which answer suits my
problem.
|
|
|
|
|
Harry's
|
Posted: Mon May 28 09:04:37 CDT 2007 |
Top |
Excel >> Total Different Cells
On May 24, 1:14 pm, "Erny" <Erny-removehyphensandthistext-
> Hi,
>
> Presuming the names are in the first column, and the amounts in the second,
> and you wish for instance to have the aggregated data in the 4th and 5th
> column:
>
> First insert a title row on top of your data and specify for instance "Name"
> on top of the first column and "Amount" on top of the second.
> Select both columns, then Use >Data >Pivot Table, accept the range of the 2
> columns, then specify that you wish to postion the results from cell D1
> onwards (provided you don't have any data there, otherwise you could also
> present the results in adifferentsheet.
> Then, add the "Name" variable to the "row" area, and the "Amount" variable
> to the "Data" area. As a result you will have the table you wish in a nice
> format...
>
> Hope this helps,
> Erny
>
>
>
>
> >I have a list ofcellsin two rows:
>
> > Harry 40
> > John 41
> > Harry 13
> > Bob 20
> > John 23
> > Bob 23
>
> > I need to extract thetotalof each person and enter in another TWO
> > rows by name and amount. Only one name for each person will appear.
>
> > As:
> > Harry 53
> > John 64
> > Bob 43
>
> > NOTE:--Alpha'd if possible.
>
> > Thanks.
>
> > Etc.- Hide quoted text -
>
> - Show quoted text -
Thanks..it works. Now I have to figure out which of the two solutions
fit my problem.
This is a great place (with brains to match) to get answers.
|
|
|
|
|
|
|