Advertisement

07.18.2008 at 01:54AM PDT, ID: 23576163
[x]
Attachment Details

Excel VBA - Find duplicate rows and sum the values

Asked by jannhan in Microsoft Excel Spreadsheet Software, Visual Basic Programming

I have no idea how to start working on this function. I have two columns, A contains people names while B contains numbers. I need a macro that can find column A for people with the same name and sum the numbers.

Example: I have this:
A          B
John    5
John    3
John    1

After running the macro:
A          B
John     9

Any guide or tips is appreciated. ThanksStart Free Trial
 
Keywords: Excel VBA - Find duplicate rows and …
Title
1 macro sum
2 SUM AND AVERAGE OF COLUMNS
3 Sum column in datagrid
4 Help with syntax of a vba range definiti…
5 Complicated Sum Required
6 Rounding a sum in a computed column
 
Loading Advertisement...
 
[+][-]07.18.2008 at 02:09AM PDT, ID: 22033927

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.18.2008 at 02:12AM PDT, ID: 22033944

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.18.2008 at 02:26AM PDT, ID: 22034016

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.18.2008 at 02:29AM PDT, ID: 22034032

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.18.2008 at 02:40AM PDT, ID: 22034079

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.18.2008 at 12:43PM PDT, ID: 22039110

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.20.2008 at 04:05AM PDT, ID: 22045250

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.20.2008 at 08:23PM PDT, ID: 22047880

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.20.2008 at 08:30PM PDT, ID: 22047893

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.20.2008 at 10:13PM PDT, ID: 22048153

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Excel Spreadsheet Software, Visual Basic Programming
Sign Up Now!
Solution Provided By: saurabh726
Participating Experts: 3
Solution Grade: A
 
 
[+][-]07.21.2008 at 12:51PM PDT, ID: 22053746

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628