+ Reply to Thread
Results 1 to 4 of 4

Return and split, Summarize the values combined in a cells of column A.

  1. #1
    Forum Contributor
    Join Date
    08-19-2020
    Location
    Dubai
    MS-Off Ver
    Office365
    Posts
    121

    Return and split, Summarize the values combined in a cells of column A.

    Hi,


    I need a formula help to split and sum a values based on values contains in a column A, In column A values is combined as month and Equipment and the Hours, it shall need to split and Summarize as in a Summary-1 (Column C to E) as like Month & Equipment & and Hours. As well in Summary-2 (Column G to H) based on values of Column A required to return an Total Equipment List and its Total worked Sum values.

    Sample sheet are attached,


    Thanks for the help,

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Return and split, Summarize the values combined in a cells of column A.

    Hi

    Is your data representative?
    In that case, you can use 'Data to columns' with the 'space' tab to split your data and a pivot table to summarize.

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,522

    Re: Return and split, Summarize the values combined in a cells of column A.

    In C4, to get real 1st date of month, formatted as "mmm-yy"

    Please Login or Register  to view this content.
    E4, hours upto 6 digits

    Please Login or Register  to view this content.
    D4:

    Please Login or Register  to view this content.
    G4: list of unique name:

    Please Login or Register  to view this content.
    Array formula, confirmed by Ctrl-shift-enter

    H4:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    08-19-2020
    Location
    Dubai
    MS-Off Ver
    Office365
    Posts
    121

    Re: Return and split, Summarize the values combined in a cells of column A.

    Its worked perfectly thanks to all for your suggestions and formulas.

+ 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. Replies: 2
    Last Post: 02-18-2020, 12:51 AM
  2. [SOLVED] Summarize table, remove null values, return column headings as rows
    By TFiske in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2018, 12:05 PM
  3. [SOLVED] How do i Summarize values from multiple sheets using vlookup combined with...?
    By BillaBoo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2016, 07:43 AM
  4. Replies: 9
    Last Post: 03-26-2014, 05:47 AM
  5. [SOLVED] How to return with combined value from different cells with same name?
    By dshwangbo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2013, 06:03 AM
  6. Replies: 1
    Last Post: 07-03-2013, 12:14 AM
  7. [SOLVED] return $$$ amount if two combined cells match
    By pcarman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2012, 01:28 PM

Tags for this Thread

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