Hi

I have an excel sheet with 2 columns...it something like this

a 2
a 1
b 4
b 3
b 1
c 0
d 5
d 7
d 1......

I wish to make a new worksheet which adds the 2nd column for each same
entry in the 1st column

so
a 3
b 8
c 0
d 8


is it possible?


Thanks in advance!!!!


--
shrutikhurana
------------------------------------------------------------------------
shrutikhurana's Profile: http://www.excelforum.com/member.php...o&userid=29868
View this thread: http://www.excelforum.com/showthread...hreadid=509408

If there are very few names, then use SUMIF.
If there are many names, use a pivot table.
--
Gary''s Student


"shrutikhurana" wrote:


Hi

I have an excel sheet with 2 columns...it something like this

a 2
a 1
b 4
b 3
b 1
c 0
d 5
d 7
d 1......

I wish to make a new worksheet which adds the 2nd column for each same
entry in the 1st column

so
a 3
b 8
c 0
d 8


is it possible?


Thanks in advance!!!!


--
shrutikhurana
------------------------------------------------------------------------
shrutikhurana's Profile: http://www.excelforum.com/member.php...o&userid=29868
View this thread: http://www.excelforum.com/showthread...hreadid=509408

Thanks for your reply.

How exactly will pivot table work?


--
shrutikhurana
------------------------------------------------------------------------
shrutikhurana's Profile: http://www.excelforum.com/member.php...o&userid=29868
View this thread: http://www.excelforum.com/showthread...hreadid=509408

Somebody pls guide me regarding how to use pivot table in this case to
get a final worksheet with no repetitive entries of column 1, and the
total of the repetitive entries in column 2 for each entry of column 1


--
shrutikhurana
------------------------------------------------------------------------
shrutikhurana's Profile: http://www.excelforum.com/member.php...o&userid=29868
View this thread: http://www.excelforum.com/showthread...hreadid=509408

-select your source table
-Goto- DataSubtotals
"at each change in"-selectcol"a"
"use function" - select'sum"
-click"ok"

you will get your list!

-via135



shrutikhurana Wrote:
Somebody pls guide me regarding how to use pivot table in this case to
get a final worksheet with no repetitive entries of column 1, and the
total of the repetitive entries in column 2 for each entry of column 1


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=509408

thanks so much!! never knew about this function


--
shrutikhurana
------------------------------------------------------------------------
shrutikhurana's Profile: http://www.excelforum.com/member.php...o&userid=29868
View this thread: http://www.excelforum.com/showthread...hreadid=509408