Simple consolidation by date

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Simple consolidation by date

  1. #1
    Board Regular
    Join Date
    Jul 2004
    Location
    Pasadena
    Posts
    126
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Simple consolidation by date

     
    Hello, I want to convert this:
    Excel 2016 (Windows) 32 bit
    Name
    Date
    Hours
    Bob
    1/1/2017
    4.5
    Bob
    1/1/2017
    3.5
    Bob
    1/2/2017
    4.5
    Bob
    1/2/2017
    5
    Mary
    1/1/2017
    3.5
    Mary
    1/1/2017
    3
    Mary
    1/2/2017
    6
    Mary
    1/2/2017
    2.5
    Sheet: Sheet1

    to this:
    Excel 2016 (Windows) 32 bit
    Name
    Date
    Hours
    Bob
    1/1/2017
    8
    Bob
    1/2/2017
    9.5
    Mary
    1/1/2017
    6.5
    Mary
    1/2/2017
    8.5
    Sheet: Sheet1
    Thanks for your help!

  2. #2
    Board Regular
    Join Date
    Apr 2012
    Location
    Texas, USA
    Posts
    515
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Simple consolidation by date

    You're looking to summarize your table, then, right? Maybe a pivot table?

  3. #3
    Board Regular
    Join Date
    Jul 2004
    Location
    Pasadena
    Posts
    126
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Simple consolidation by date

    I'm looking to build a new table which I can pivot off. If I pivot off the existing data, it gives me headers by Name which makes it difficult to look at totals by date (my data set is very large...years of dates and name). Thanks.
    Thanks for your help!

  4. #4
    Board Regular
    Join Date
    Apr 2012
    Location
    Texas, USA
    Posts
    515
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Simple consolidation by date

    I'd say VBA or run the advanced filter the first two columns (no criteria, check unique) and use a SUMIFS formula to populate the totals for the third column.

  5. #5
    Board Regular
    Join Date
    Jul 2004
    Location
    Pasadena
    Posts
    126
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Simple consolidation by date

      
    Terrific. I'll give it a shot. Thanks for the suggestion.
    Thanks for your help!

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com