+ Reply to Thread
Results 1 to 19 of 19

Add partial column depending on name in cells.

  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    Hernando, Florida
    MS-Off Ver
    Excel 2007
    Posts
    12

    Add partial column depending on name in cells.

    I am trying to find a way to add numbers from cells in col 2 and col 3 when the name in col 1 is the same. I want to put the totals in col 5 and 6 on the lowest row with the same name. I attached a file as an example of what I have and I hope I explained my problem so it is understandable.

    Thanks in advance
    Larry
    Attached Files Attached Files

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Add partial column depending on name in cells.

    Please find the file attach and hope the best......


    regards
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Add partial column depending on name in cells.

    Or with a pivot table.

    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Add partial column depending on name in cells.

    Azumi, that was a nice way of selecting the rows that need to be completed!! Can the SUMPRODUCT not be simplified to

    =IF(COUNTIF($A$2:$A$20,$A2)=COUNTIF($A$2:$A2,$A2),SUMPRODUCT(($A$2:$A$20=$A2)*(B$2:B$20)),"")
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  5. #5
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Add partial column depending on name in cells.

    Quote Originally Posted by Glenn Kennedy View Post
    Azumi, that was a nice way of selecting the rows that need to be completed!! Can the SUMPRODUCT not be simplified to

    =IF(COUNTIF($A$2:$A$20,$A2)=COUNTIF($A$2:$A2,$A2),SUMPRODUCT(($A$2:$A$20=$A2)*(B$2:B$20)),"")
    You're right thanks Glenn

  6. #6
    Registered User
    Join Date
    08-23-2012
    Location
    Hernando, Florida
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Add partial column depending on name in cells.

    oeldere, thank you, I looked at your attachment and it looks like what I want. I will now read up on pivot tables.

    Thanks also to the others who replied and tried to help me. I am too new to understand most of what is being said in here but I am learning.

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Add partial column depending on name in cells.

    You're welcome. We appreciate the feedback!

    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

    It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

    If you have other questions on this item, just ask.

  8. #8
    Registered User
    Join Date
    08-23-2012
    Location
    Hernando, Florida
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Add partial column depending on name in cells.

    I have been playing around with the pivot table option. I have learned some things but so far I have not learned how to add the column with the totals next to the columns that I already have. I did learn how to make a sheet with only totals next to the names. This will help me a lot. But I will keep working on this for a while to see if I can grasp more of how it works. My next problem is to find out if I can have a sheet with a blank pivot table that will import the data and be in the same format as the table I created.

    Thanks again.

  9. #9
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Add partial column depending on name in cells.

    Enter this in D2 and fill across and down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  10. #10
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Add partial column depending on name in cells.

    Fill in the data in the table on Sheet2 then refresh the Pivot table on Sheet3.
    Attached Files Attached Files

  11. #11
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Add partial column depending on name in cells.

    And to refresh the data (in #10)

    Excel 2013 => data = refresh

    If you want explaination on the pivot table, just ask.

  12. #12
    Registered User
    Join Date
    08-23-2012
    Location
    Hernando, Florida
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Add partial column depending on name in cells.

    Yes I must ask. What is a partial column? How do you add it? It may not be worth your time to try to explain all of this. Sorry for not understanding.


    Larry

  13. #13
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Add partial column depending on name in cells.

    A partial column has no meaning for Excel - it's the term that YOU used to describe what you wanted. The contributions that have been made fall into two types: those that tried to reproduce the FORMAT of your desired result (e.g. Azumi & myself) and those that tried to reproduce the INFORMATION that you wanted in a different format (Oeldere). Did you look at the solutionsoffered at Posts 2 and 4. Do they not match exactly what you had asked for in Post 1?

    Comment for NDM: I had tried that earlier, but if (e.g.) Jones reoccurrs later on in the listing, it all goes pear-shaped...

  14. #14
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Add partial column depending on name in cells.

    For your reply in #12:

    Since you have answers from several members, it is usefull to add to whom or to what # you are replying

    If you reply to me, I don't understand the question, so in that case you have to explain once again (better).

  15. #15
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Add partial column depending on name in cells.

    Upload a workbook with the results that you want manually entered. Your column terminology is impossible to follow as it isn't used in Excel. You have several answers but no real response as to what is addressing your problem.

  16. #16
    Registered User
    Join Date
    08-23-2012
    Location
    Hernando, Florida
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Add partial column depending on name in cells.

    It seems I am not even asking the questions in a way that makes sense to the experts here. I also screwed up when I titled my first post, I did not mean partial column I meant additional column. And then I did not realize it was me that started the "partial column" thing. Sorry.

    I looked over the answers and saw that azumi put a file on here that did what I wanted. But without an explanation of how he made the file I did not understand how I could duplicate it. Unless the formulas have to be redone every time the frequency of a name changes in column 1.

    oeldere got me to looking at pivot tables and that seems to be where I need to go. I have been trying to learn about them and slowly making progress. I am sorry if I do not speak the language but it will eventually sink in.

    I have progresses quite a bit in understanding pivot tables. I want to thank all who have posted here with your ideas to help me.

    I am going to go forward with the pivot tables until I understand them well enough to do what I want.

    Thanks you, one and all
    Larry

  17. #17
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Add partial column depending on name in cells.

    @Larry Ryan

    Thanks for taking the time, adding a clear reply.

    I realy appreciate that.

  18. #18
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Add partial column depending on name in cells.

    @Larry Ryan
    Take a look at the 2 solutions that I gave you in msg #10.

    I have given you a formula driven solution on Sheet1 and sheets 2 and 3 have a blank table that when filled out will populate the pivot table when you right click in the pivot table and choose refresh.

  19. #19
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Add partial column depending on name in cells.

    This is updated from my previous file.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Partial Match in a column that returns the cells to the right.
    By lamenters in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-29-2014, 11:38 AM
  2. Replies: 2
    Last Post: 06-18-2013, 10:26 AM
  3. Match partial cells in a single EXCEL column?
    By kpratico in forum Excel General
    Replies: 7
    Last Post: 06-05-2012, 03:21 PM
  4. Replies: 1
    Last Post: 10-28-2011, 01:39 PM
  5. Merge Cells depending on another column
    By sp123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2006, 04:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1