+ Reply to Thread
Results 1 to 15 of 15

code sum and merge data based on repeated data

  1. #1
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    code sum and merge data based on repeated data

    hi,
    i would get code to sum data and merge i put my expected result from f4:h6
    Attached Files Attached Files
    Last edited by ABDELFATTA; 05-24-2020 at 08:50 AM.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Exclamation Re: formula sum and merge data based on repeated data


    As here again it's the VBA forum so better ask on the appropriate forum …

  3. #3
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: formula sum and merge data based on repeated data

    hi, Marc
    forgive me about this i see many members demand formula about them subjects actually i asked that i don't make difficult this for members that's why i requested by formula , indeed i prefer vba because dynamic and fast

  4. #4
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: formula sum and merge data based on repeated data

    Sorry Marc I do not notice the existence of the equations section, I hope to accept my apology

  5. #5
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: formula sum and merge data based on repeated data


    No problemo !

    It's just to give you more chances the next time in the appropriate forum even if sometimes here some helper may answer …

  6. #6
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: code sum and merge data based on repeated data

    a i adjusting my post maybe find feedback

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

    Re: code sum and merge data based on repeated data

    How about pivot table?

    Fast and dynamic.

    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.

  8. #8
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: code sum and merge data based on repeated data

    thanks eoldere i prefer code if is possible indeed i 'm not good at pivot table or power query i don't know how i can use them the code is dynamic and quick that's why i prefer code

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

    Re: code sum and merge data based on repeated data

    You did not replied if the file contains the solution for your question.

    "i 'm not good at pivot table or power query"

    If it is, you can also learn pivot tables, since it is very powerfull tool for data analyse.

  10. #10
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: code sum and merge data based on repeated data

    this is not what i would i want merge data in one row each repeated data as what i put in above my sheet but pivot table i have to pull down arrow each repeated data separetly this is not practical i 'm sorry said that

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

    Re: code sum and merge data based on repeated data


  12. #12
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: code sum and merge data based on repeated data

    yes, oeldere but if i add a new data how update the new data

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

    Re: code sum and merge data based on repeated data

    Then you only need to refresh the data.

    After that the data is in the range.

    Data => refresh data.

  14. #14
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: code sum and merge data based on repeated data

    how i can do pivot table like you i would learn this by steps if you don't mind i don't just copy and paste maybe i need adjusting different range in the future

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

    Re: code sum and merge data based on repeated data



    I will guide you.

    Put the cursor in cell A5 (in the table).

    => Then choose.

    Insert => Table

    => My table contains headers is clicked on.

    => Ok.

    Now you have a table, wich will expand every time you add new data, directly under the last left cell of the table.

    Then you gonna create a pivot table.

    Insert => pivot table.

    Choose for OK.

    In that case it will make a new pivot table in a new sheet.

    After that
    On the right side you will find 4 boxen.

    Drag name in column.

    Drag code in rows

    Drag salary in value.

    After that you have the result I had in the file (oeldere2).

    Try it, and if you have problems, show what you have done in an excel file.

    After that I will help you solving that problem.
    Last edited by oeldere; 05-24-2020 at 11:10 AM.

+ 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] Data Repeated Based On Number in Adjacent Cell
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2018, 10:33 AM
  2. [SOLVED] Formula or way to count repeated data in a list of cells?
    By Robbyvictoryop in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-02-2017, 02:42 PM
  3. [SOLVED] Multiple formula rows from single row of data, repeated for each row of data
    By tomin21 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-14-2016, 01:33 PM
  4. [SOLVED] Copying data based on repeated values in a column
    By ClickingNoise in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-05-2013, 04:34 AM
  5. [SOLVED] Append data to repeated values with a fixed array to be repeated on value change
    By anchuri_chaitanya in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-06-2011, 12:30 AM
  6. How to merge repeated data cell in Excel?
    By indra in forum Excel General
    Replies: 8
    Last Post: 10-30-2009, 07:54 AM
  7. Delete a row based on multiple column repeated data
    By Omega in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2005, 03:26 AM

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